Data refresh process

[ani_informa]

Hi

I want to know how Power BI service refresh data. Consider an example if I have 20 million rows in my fact table and 0.2 million rows in dimension table. now supposed if I schedule to refresh Power BI dataset then it reloads all 20 million rows every time I refresh or it identify newly added rows and refresh those only ?

[GilbertQ · Accepted solution]

Hi there

Currently that is correct for imported Power BI datasets using Power BI Pro.

If you have Power BI Premium, you can then configure Incremental refreshing which would then allow you to only update the latest data.

[ani_informa]

so you mean to say that Power BI service updates all data every time scheduled refresh happen ?

[GilbertQ]

Yes that is correct, and depends on how you configure the refresh schedule.