Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

rajesh2001

Why is the On Demand Refresh faster than Schedule Refresh

Submitted by Advocate I on ‎04-29-2017 09:31 PM

Hi Team,

 

We have been noticing that when we hit Refresh now on the dashbaords , it finishes fast like within 2 minutes vs a scheduled Refresh takes about 14 minutes .

 

What is the difference between these as they should have more or less the same time 

 

 

Status: New
See more ideas labeled with:
29 Comments (29 New)
Comments
rrr3521
Frequent Visitor
‎11-14-2018 06:52 AM

Hi - 

 

I'm experiencing the same issue.

 

 

I'm wondering if this is happening for Premium users, too. 

We only have Pro, so they put us on a shared server. And with many other scheduled dataset refreshes on the shared server at the same times, perhaps that's what causes things to slow down? I don't know.

 

 

I've tested the data refresh using the data refresh API and it is faster that way than the scheduled approach.

  

Since there's no solution for this yet, we will be switching our scheduling to use these API's instead.

 

We are using PowerShell scripts described here

 

Anonymous
Not applicable
‎12-17-2018 07:12 AM

 Hi @rrr3521:

 

I'm pro user too, so I'm sorry that I could not provide you with help.

 

Thanks so much for sharing your solution!

 

Sincerely,

Chen

 

 

Anonymous
Not applicable
‎12-20-2018 12:30 AM

Experienced the same in multiple tenants. On demand refresh takes only like 1/10th of the time.

RémiDubois
Regular Visitor
‎02-08-2019 07:49 AM

Problem happens for my customers as well

1 minutes for manual refresh in service

14 min for scheduled...

 

Hopefully this gets an answer at some point/some visibility in community !

 

Br,

R.

luxpbi
Helper V
Helper V
‎02-13-2019 08:33 AM

Same problem for me. It would be great to understand that difference.

Anonymous
Not applicable
‎03-07-2019 06:03 AM

Same problem for me. Also, the Salesforce data dissappears with the scheduled refresh but not with the refresh on demand...

jnelsoncpath
Regular Visitor
‎03-20-2019 03:52 PM

Same for me.  I am refreshing SharePoint lists that display in Power BI as data tables with only a couple of columns and under 20 rows.  Manual refresh takes 2 seconds.  2 seconds.  Auto refresh is a minimum of 10 minutes and its gone all the ay up to 55 minutes.  Again we are talking about hardly any data.

Anonymous
Not applicable
‎06-02-2019 11:12 PM

Did anyone ever figure this out?

appsac
Advocate I
Advocate I
‎08-20-2019 11:28 AM

I just reported this issue to Microsoft Support.  A support guy called me from India.  I could barely understand him.  He wanted to remote into my computer, which I thought was odd since this issue is happening on the PBI Service, not my computer.  He tried to convince me that the scheduled refresh takes longer because it doesn't have a "direct connection" to my on-prem database servers.  That makes no sense.  The refresh now process goes through the Gateway just the same as a scheduled refresh process.  Anyway, it's a problem that I hope Microsoft will address soon.

Anonymous
Not applicable
‎08-21-2019 02:03 AM

@appsac  I agree with you, his explanation is not so reasonable. I think there must be a Queuing mechanism thing when updating the report via scheduled refresh.

Idea Statuses