Performance difference between on-demand update and scheduled update

[PedroGomesANCD]

Hi,

My dataset has a scheduled update and taking 10-15 minutes to finish.
When I run on-demand update, it only takes 2-3 minutes.
Both updates go through the gateway.
Can someone help me?

Thanks,

[YinchTan]

Hi have similar observation on the API triggered refresh, this is from Power Automate script, the refresh time is 15 seconds as opposed to ~5 miniutes in the scheduled refresh, and it's very consistent every time.

[v-chenwuz-msft]

Hi @PedroGomesANCD ,

Whether they are manually refreshed or scheduled to be refreshed, their process is the same. Only, the start time and the actual time of the scheduled refresh are not the same. And the power bi service ensures user interaction first when there is not enough memory, and starts refreshing data only when there is enough memory. And the network factor will also affect the refresh process.

For more details, you can refer this official article.

Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

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

[PedroGomesANCD]

Hi @v-chenwuz-msft ,

I understand, but our network does not show any instability during the update process.
The only difference really is that on demand process it is faster.

Do you think any configuration changes in the gateway file would make any difference?

I just did a new manual update and the time difference is very big.

Thank you for your help!

[v-chenwuz-msft]

Hi @PedroGomesANCD ,

For scheduled refresh, it has a certain delay. You can refer to specific official documents:

Data refresh in Power BI - Power BI | Microsoft Docs

You can find out the actual time it refreshed, by checking the gateway logs.
As far as I know there is no special setting for scheduled refreshes.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak]

@PedroGomesANCD , You have done it just after the last load has finished, so I doubt not much data for a refresh, depending on the setting.

can you check a manual one before the scheduled one and check

[PedroGomesANCD]

Hi!
I don't use incremental update.
The entire dataset is completely updated ever.

If I run on-demand update now, the time to complete is the same (2 minutes)