How Power BI Refresh will work on service

[bajee]

Hi Team,

I want to know how Power BI refresh will work.

EG: I have created one report by using Azure SQL Server with import data option after creating i have published on the power bi  service and scheduled the refresh.Here we not using any gateway's to refrsh the data we are using AZURE Direct connection.

when created the report i have imported 20Mil records to create.

After published report to power bi Service if any new data comes in the Azure SQL Server how power bi refresh will work it will refresh entire data including 20mil records+new data or else it will refresh only the new data.

Any idea?

Regards,

Bajee.

[Seth_C_Bauer]

@bajee It will refresh the entire dataset. So it will re-pull all records on every refresh.

[bajee]

Hi

 As per you If It will refresh the entire dataset it's taking 17Mins to refresh in Power Service.

If i refresh same report in Power Bi Desktop its taking amost 1 Hour. Why Its taking toomuch time in power desktop.

Any idea 

Regards,

Bajee.

[Seth_C_Bauer]

@bajee Your machine power vs. Hardware used to support Power BI would be my guess.