Forum Discussion

Imrans123's avatar
Imrans123
Advocate V
4 years ago
Solved

Best Practices for working with multiple Databases

Hello,    Was wondering if anyone could help suggest best practices for a new project I am doing.   I have multiple SQL Server sources   For each source, I am creating a DataFlow and writing SQ...
Need Help
Show and Tell
Tips and Tricks
  • aj1973's avatar
    aj1973
    4 years ago

    Hi Imrans123 

    1- Yes it is always better to get a view directly from the source, faster to import a saved view.

    2- Yes it is better to consolidate all the source into a Data Lake type of things.

Imrans123's avatar
Imrans123
Advocate V
4 years ago

Thanks AJ. Just out of curiosity, would you happen to know the refresh procedure with Power BI's native query is incremental?

 

Let's say with the query, I have loaded 100,000 rows. Before my next refresh, another 100 rows of data has been added in the source database. If I were to refresh the query, would Power BI Dataflows load the 100 new rows of data over the existing 100,000 rows, or will it load 100,100 as new.

aj1973's avatar
aj1973
Community Champion
4 years ago

Yes, that's called incremental refresh feature in Power Bi. It is used for that purpose however you will need Premium Capacity License for that or PPU Premium per user, it depends on your needs.