Forum Discussion
Automatic import of new databases
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?
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
3 Replies
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
Yes, all databases in the same dataset. However, every time a new database is created do I have to add its tables manually?
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
