SQL query - looping over databases

[arda23]

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!

[zoloturu]

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? 

[arda23]

Thanks @zoloturu. It is exactly what I was looking for.

[v-chuncz-msft]

@arda23,

Here is an example for your reference.

[arda23]

Hello @v-chuncz-msft, thank you for your answer. Are there any way to get all results in the same table?