Forum Discussion

SpiroswayGR's avatar
SpiroswayGR
Icon for Resolver III rankResolver III
5 years ago

Schedule vs Manual Refresh !!

Dear all,   We are trying to solve this problem lately even with Microsoft support but looks like no one can understand whats going on wrong here.   As you can see from our screenshot when the re...
Need Help
SpiroswayGR's avatar
SpiroswayGR
Icon for Resolver III rankResolver III
5 years ago

collinq 

To be honest isn't resolved yet and already made a ticket for this one.

 

I can accept a small delay due the shared server but it isn't so logical to me when i hit "refresh now" to be 4 times faster than schedule.

 

I am comparing "Refresh now" in powerbi service and schedule refresh in powerbi service too and not powerbi desktop that ofcourse is much faster around.

 

Furthermore, i am running just one report at same time so it wont be any delay from different reports and as about my capacity i have around 200 mbit and the max used was around 30mbit.

 

Thank you very much for your time and detail explainations/comments.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi SpiroswayGR 

You may refer to this blog: Scheduled refreshes are slow, manual refresh is quick

Reason: 

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,

Rico Zhou

 

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

  • SpiroswayGR's avatar
    SpiroswayGR
    Icon for Resolver III rankResolver III
    5 years ago

    Anonymous 

    We can understand that we can have a small delay but 15 more minutes is "big fail" for us cause we have also jobs in our servers to run so that cause deadlocks if time will surpass 20-25 minutes.

     

    We are checking this our with Microsoft support through gateway logs and i might come back soon with news.