Forum Discussion
Solved
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 crea...
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
Solution Sage
Solution SageAre 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