Power Bi Auto refresh taking more time than manual refresh

[v-stephen-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

A scheduled refresh does not garauntee that the refresh will execute at the exact time you set, it is shared capacity, so depending on your "neighbors" on the servers the time could be delayed a bit. When you refresh manually, it might be refreshed immediately, instead of waiting in a queue like a scheduled refresh.

This is explained in official documents:

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.

Reference: Setting a refresh schedule

Best Regards,

Stephen Tao

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

[Anonymous]

Hi Virvan 

Thanks for you response, Please see below details of on demand and auto refresh.Yes, I have scheduled auto refresh on the reporta and below is the refresh history.

On demand is taking approx 25 mins and auto scheduled refresh is taking 45 mins. Request you to please help.

Refresh history

ScheduledOneDrive

Details Type Start End Status Message

	Scheduled	11/24/2020, 8:04:32 AM	11/24/2020, 8:45:13 AM	Completed
	Scheduled	11/24/2020, 7:03:27 AM	11/24/2020, 7:39:44 AM	Completed
	Scheduled	11/24/2020, 6:04:34 AM	11/24/2020, 6:44:32 AM	Completed
	On demand	11/24/2020, 5:43:41 AM	11/24/2020, 6:07:42 AM	Completed

[vivran22]

Hey @Anonymous ,

Please share more details regarding the issue. How you have set up the auto refresh?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter