# Adding values grabbed from data source variable

**URL:** <https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529>\
**Category:** Dashboards\
**Created:** [August 13, 2024, 12:07pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529 "2024-08-13T12:07:03Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![omfedorovych](https://avatars.discourse-cdn.com/v4/letter/o/b38774/32.png) [@omfedorovych](https://community.grafana.com/u/omfedorovych)\
**Post date:** [August 13, 2024, 12:07pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/1 "2024-08-13T12:07:03Z")

</div>

Azure Managed Grafana 10.2.1

I’ve connected Grafana to multiple data sources and can switch between them using a variable. Everything works fine when only one data source variable is selected, and the data is correct. However, there are issues when I try to select multiple values. I’ve attached some screenshots for better clarity. I think I might have missed some additional calculations. Thanks for the help

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [August 13, 2024, 12:26pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/2 "2024-08-13T12:26:05Z")

</div>

what does the usage of that variable look like?

---

<div class="post-metadata">

**Author:** ![omfedorovych](https://avatars.discourse-cdn.com/v4/letter/o/b38774/32.png) [@omfedorovych](https://community.grafana.com/u/omfedorovych)\
**Post date:** [August 13, 2024, 12:33pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/3 "2024-08-13T12:33:51Z")

</div>

I`m not sure what you mean by that but here is the query I use

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [August 13, 2024, 12:42pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/4 "2024-08-13T12:42:14Z")

</div>

![image](https://us1.discourse-cdn.com/grafana/original/3X/f/0/f0e5e0cbbf077c1307f54f6246d17be7cee3899a.png)

as the name indicates you can only do **one data source.**

instead of that approach might want to look at using that variable in the query itself?

`select yadiyada from ${datasource} where x = 12` kind of thing?

---

<div class="post-metadata">

**Author:** ![omfedorovych](https://avatars.discourse-cdn.com/v4/letter/o/b38774/32.png) [@omfedorovych](https://community.grafana.com/u/omfedorovych)\
**Post date:** [August 13, 2024, 12:53pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/5 "2024-08-13T12:53:47Z")

</div>

The problem is that all data is stored across several SQL databases, with one database for each client.

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [August 13, 2024, 1:20pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/6 "2024-08-13T13:20:44Z")

</div>

Are these databases on the same sql server?

---

<div class="post-metadata">

**Author:** ![omfedorovych](https://avatars.discourse-cdn.com/v4/letter/o/b38774/32.png) [@omfedorovych](https://community.grafana.com/u/omfedorovych)\
**Post date:** [August 13, 2024, 1:26pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/7 "2024-08-13T13:26:22Z")

</div>

Yes, the server is same

---

<div class="post-metadata">

**Author:** ![omfedorovych](https://avatars.discourse-cdn.com/v4/letter/o/b38774/32.png) [@omfedorovych](https://community.grafana.com/u/omfedorovych)\
**Post date:** [August 13, 2024, 2:20pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/9 "2024-08-13T14:20:55Z")

</div>

Understood, thanks a lot for your help again)  
We use different databases for a more reliable and fast syncing process.

---

<div class="post-metadata">

**Author:** ![yosiasz](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/yosiasz/32/45847_2.png) [@yosiasz](https://community.grafana.com/u/yosiasz)\
**Post date:** [August 13, 2024, 2:31pm UTC](https://community.grafana.com/t/adding-values-grabbed-from-data-source-variable/128529/10 "2024-08-13T14:31:42Z")

</div>