Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello friends,
I want to use Power BI to visualize usage of our products in certain periods. All of our clients have their own databases. My query has to look for all the clients' databases. Looping is necessary for this but I could not find how I can do that.
Also, if you can explain me, how can I create variables in the query. For example: date1 = dd/mm/year, date2 = dd/mm/year
Note: I connected with ODBC connector to databases.
Thanks in advance!
Hi @arda23,
In Advanced edit, you can edit M query which is used to connect to the source. You can create a manual table with a list of DB connection strings and additionally function which you can invoke for each of rows in the table mentioned before.
Regarding variables, you just write
DBName = "mydatabasename", varDate = "dd/mm/yyyy"
Is it what you need?
Hello @v-chuncz-msft, thank you for your answer. Are there any way to get all results in the same table?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |