Forum Discussion
Why Power BI Services late to start refresh?
I set up scheduled refresh on one of my reports, but it takes around 15 min to start the refresh and takes another 10 minutes but when I refresh the report on demand takes around 2 minutes.
This is my scheduled refresh configuration for the report.
and this is my refresh history
if you can see takes more time as usual when it refrehs automatically.
Can anyone know why takes a delay when is automatic?
Plese help me.
Thanks,
Luis N.
HI Anonymous
When you schedule a refresh in Power BI Service, that refresh request enters a queue and may wait in the queue for up to an hour before being picked up and run. This is Microsoft managing the load on the Power BI servers which are used by all the Power BI community. Manual refreshes are not queued but run straight away, so they appear to take less time.
So this is why an Automated Refresh may appear to take longer as it spends more time in the queue waiting to run.
If the time taken to refresh is important to you, you may be able to shorten the queue wait by scheduling a refresh outside of busy business times. Scheduled refreshes at 9:00PM are often quicker than those at 9:00AM.
Aside from that, there's not much else you can do apart from using a Premium Capacity or Premium Per User licence. The Premium licences run on dedicated capacity, so don't need to share with the rest of the community, hence queue times can be much shorter.
Hope this helps
Stuart
5 Replies
- Burningsuit
Resident Rockstar
HI Anonymous
When you schedule a refresh in Power BI Service, that refresh request enters a queue and may wait in the queue for up to an hour before being picked up and run. This is Microsoft managing the load on the Power BI servers which are used by all the Power BI community. Manual refreshes are not queued but run straight away, so they appear to take less time.
So this is why an Automated Refresh may appear to take longer as it spends more time in the queue waiting to run.
If the time taken to refresh is important to you, you may be able to shorten the queue wait by scheduling a refresh outside of busy business times. Scheduled refreshes at 9:00PM are often quicker than those at 9:00AM.
Aside from that, there's not much else you can do apart from using a Premium Capacity or Premium Per User licence. The Premium licences run on dedicated capacity, so don't need to share with the rest of the community, hence queue times can be much shorter.
Hope this helps
Stuart
If that's true then why when I click refresh now, it kicks off immediately without going into a queue? Why does it only queue schedules? This is stupid what powebi does for no reason...
Hello everyone
I came accross this post and I have the same problem but a premium workspace.
Any idea why I'm still experiencing a queue ? I only have 2 refresh scheaduled in this workspace at the moment.
Im getting the same thing on prem per user workspace, can start as much as 6 mins late. Did you ever get to the bottom of it?
the same here. even with the premium capacity the refresh's delay is about 30 minutes.
