Automatic import of new databases

[gabrielkohler]

Hello,

I have a demand from a client that has several franchises, each franchise has a database that is allocated on the same server. I need to know if there is a way, when a new database is created on the server, that power qwery automatcly import the tables that I will leave programmed?

[gabrielkohler]

Yes, all databases in the same dataset. However, every time a new database is created do I have to add its tables manually?

[ppm1 · Accepted solution]

You can see all the databases on the server, either by right clicking on the server in the Get Data pop-up window (don't choose one database or table) and select "Transform Data". Or you can modify/remove the navigation step to get to same view. Once there you can add a column to extract the table from each database and append. Repeat for the other tables to combine. Example with sql server below.

Pat

[ppm1]

Are you loading all the databases into the same Power BI dataset? Appending the same tables from each database? If so, it should just pick up the new databases with each refresh.

Pat