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.
Hi guys,
I have a bunch of databases (100+) that all have the same schema and are living on several different SQL servers (10+).
I have a master table on a separate database that lists the names of all my databases and on which server they live.
Now what I'd like to achieve is to combine the data from one of the tables that exists in all these databases with PowerQuery.
One option is to manually create a power query for each of them, but it would be very hard to maintain.
So I'd like to have a way to dynamically query each database.
I haven't found how to do that but I feel like it's feasible.
In a nutshell, what I'd like to do is:
- Get list of Servers and Databases from master
- For Each Database in list:
- Get data from Table Bob
- Append to QueryBob
Is there a way to do this with PowerQuery?
Solved! Go to Solution.
Yes it can be done. In short,
read my article here. This is an Excel example, but the principle is the same for your use case.
https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/
Yes it can be done. In short,
read my article here. This is an Excel example, but the principle is the same for your use case.
https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/
Thanks Matt, that works!
And...
PowerBI service doesn't allow to refresh when functions are used in PQ...
Please vote for this!!
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 | |
100 | |
86 | |
64 |