cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fbackes
Helper I
Helper I

Scheduled refresh always takes three times as long as on-demand refresh

Each scheduled refresh takes three times as long as on-demand refresh. Is this a bug or a feature?

 

 

6 REPLIES 6
v-shex-msft
Community Support
Community Support

HI @fbackes,

 

Based on document, it said that the 'scheduled refresh' not fully accurate refresh, it may have some delay.

 

Note:

When you configure a time for scheduled refresh, there can be a delay of up to one hour before it begins.

 

Reference link:

Data refresh in Power BI

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Reading the question I don't think @fbackes is talking about the time the refresh starts but rather the time the refresh takes to complete from start to finish. I have the same question. When I watch my refresh happening in it takes much much longer to complete than a manual refresh. Any idea why that is?

Hi @Justair07 ,

 

I'm having the same refresh duration difference between manual refresh and scheduled refresh. Have you figured out why this happened? Thanks!

 

Lexi

Hi @LexiQiang,

 

Sorry for the late response. I believe it has to do with using a gateway. When using a gateway I'm speculating that whatever VM is being used has something to do with it. Do you use a gateway?

Hi, I can see this is an old topic and even now the issue is the same. When the refresh is scheduled it takes almost 30m to finish, however when I click the button to refresh it only takes around 2minutes (from the same PBI service webpage).

 

If I open the report in PowerBI for desktop and refresh the data it takes 2minutes also. I'm not using any gateway, all data source is in Sharepoint.

 

So did anyone find out why is this happening or what is the workaround?

 

Thanks in advance.

@fbackes The scheduled refresh time is not the Exact time the refresh will take place. From my understanding the goal is that it kicks off within the hour (usually ~30 minutes) from the scheduled refresh time that was set. This is most likely why it appears to take longer, because it hasn't actually executed.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors