cancel
Showing results for 
Search instead for 
Did you mean: 

Dataset scheduled Refresh is taking too long

Hi,

 

My scheduled refresh is taking too long and also refresh start time displays delayed start. But on demand refresh is very very quick.

Please advise.

 

Thanks,

Shirish

 

ScheduledRefreshTooLong_2021-04-28.png

Status: New
Comments
v-lili6-msft
Community Support

hi

First, power bi scheduled refresh delay is a normal phenomenon in power bi.

 

Having configured a refresh schedule, the dataset settings page informs you about the next refresh time, as in the screenshot above. If you want to refresh the data sooner, such as to test your gateway and data source configuration, perform an on-demand refresh by using the Refresh Now option in the dataset menu in the nav pane. On-demand refreshes don't affect the next scheduled refresh time.

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.

 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#setting-a-refresh-schedule

 

and for why scheduled Refresh is slower than demand refresh, have a look this post:

 

https://community.powerbi.com/t5/Service/Scheduled-refreshes-are-slow-manual-refresh-is-quick/td-p/1...

 

I think the issue with scheduled refresh is that it does not start at the top or bottom of the hour, even though that's the time you have chosen.  For example, you schedule a daily refresh for 12:00 am.  It goes into a queue at 12:00, but it can take 15 + minutes to start.  However, when you do a manual refresh, it starts immediately.  This is a limitation of shared capacity model.

 

 

Regards,

Lin

chalapathy
Frequent Visitor

Hi Lin

This is understood. But the duration (start time to end time) difference is huge between on demand and scheduled.

I have similar issue.