Scheduled Refresh

[Anonymous]

Hey,

I'm trying to set up a scheduled refresh for a dataset that pulls from salesforce reports. When running a manual refresh the data refreshes in a matter of seconds. However, the scheduled refresh has been running for close to 10 minutes. Not sure what can be done to fix this issue.

[v-yingjl]

Hi @Anonymous ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to

help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @Anonymous ,

Based on my research, The reason scheduled refresh takes longer is because PBI smooths scheduled refresh so AS Engine and Gateway is not flooded with request. PBI doesn't do smoothing for on-demand refresh.

Such as if you set scheduled refresh at 9:00 am, it may start at 9:14 am, and end in 9:16 am, so seems it refresh 10 - 15 min, but if execute an on-demand refresh at 9:00 am, it will start right now and may end in only few minutes. This document also mentioned : 

Note also that the configured refresh time might not be the exact time when Power BI starts the next scheduled process. Power BI starts scheduled refreshes on a best effort basis. The target is to initiate the refresh within 15 minutes of the scheduled time slot, but a delay of up to one hour can occur if the service can't allocate the required resources sooner.

If you needs the report be ready by certain time, schedule the refresh ahead of the time or execute on-demand refresh.

Best Regards,
Yingjie Li

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

[GilbertQ]

Hi there

The reason is that when it is scheduled it is scheduled with a whole bunch of other datasets also getting refreshed at the same time.

Unless you need it refreshing every few minutes, is there any issue with it taking a bit longer to refresh?