Forum Discussion
Combining several similar databases
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 nam...
Yes it can be done. In short,
- you connect and load one of the tables
- convert that query into a function
- get a list of all tables into a query
- pass the list to the function for conversion
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,
- you connect and load one of the tables
- convert that query into a function
- get a list of all tables into a query
- pass the list to the function for conversion
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!!