cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ferrus
Frequent Visitor

Why is refresh go faster when it's manually ordered?

Hello guys,

 

Just would like to understand why is my Dataset refreshed faster when I do it manually than a scheduled refresh ?

Manually is less than 5 min and scheduled could be up to 20-25 min...

 

I also noticed the time can be longer when it takes place in morning, afternoon or at night...

 

Thanks !

1 REPLY 1
arvindsingh802
Super User
Super User

Are your using Premium Capacity/On Premise Gateway
If Yes - There multiple refreshes are happening at same time thus a refreshes are waiting in queue.

 

Manual refresh has priority over shedule refresh thus when you hit manual refresh it skip the scheule refresh queue and get refreshed eairlier.

 

To resolve the issue increase the resources or optimise your schedule refreshes to distribute evenly
I would also recommand to implement incremental refresh to all your long refreshing dataset/dataflow to reduce the refresh time.

 

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!

 


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!