Download New Databases

[DinoDan]

I am extracting databases (all with the same format and layout, just different names) from a SQL Server.  So currently I have a list like:

DB1

DB2

DB3

.... and so on

Those DBs have been imported into PowerBI and I have created a few reports based on this data.  They are brought into a single query that formats them in the way that we need it to be.  At this point, I currently have 25 DBs imported, which took a long time to import.  In the future we will be adding new DBs and will need to import them to PowerBI.  

Is there a way that I can append a new DB to the query that has all of the other data?  I am wondering because of the size of each DB, the loading time takes well over an hour.

Thanks!

[v-rzhou-msft]

Hi @DinoDan ,

As far as I know, too long loading time may be caused by large size of data or complex query in your data model. Here I suggest you to optmize your data model based on below offical blog to get better Power BI Performance.

For reference:

Optimization guide for Power BI

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.