Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PedroGomesANCD
Regular Visitor

Performance difference between on-demand update and scheduled update

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,

PedroGomesANCD_0-1646834882270.png

 

5 REPLIES 5
v-chenwuz-msft
Community Support
Community Support

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.

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!

 

PedroGomesANCD_0-1647359185432.png

 

Hi @PedroGomesANCD ,

 

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

vchenwuzmsft_0-1647396211880.png

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
Super User
Super User

@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

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)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.