Forum Discussion
Workspace Resource Metrics (pro vs premium)
Hi rusgesig
You have to remember that a Pro licence is not using a dedicated resource, but is shareing the Microsoft Service servers with all other Power BI Pro licence users in your geographic area.
When a Pro licence schedules 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 that have Pro licences. Manual refreshes are not queued but run straight away, so they appear to take less time.
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
Thanks Selina,
I would however like some more specific info.
>If you set the corresponding refresh time, the data set will be refreshed at the corresponding time point.
Please see attached export of refresh times via the api:
There are 6 datasets in the workspace, three of them scheduled to run on the 30 minute mark, and three on the hour mark. The three in the screenshot are all scheduled to start at 09:30. The workspace is normal pro capacity, and usage is 200mb of 10gb.
As you can see the start times are inconsistent - which is what I mean by simultaneously refreshing or staggering. Do all three datasets start a refresh request at 09:30 and then vie for resources to see which one gets started first?
How can I quantify/predict the starting delay/duration based on resource consumption?
Hi rusgesig
You have to remember that a Pro licence is not using a dedicated resource, but is shareing the Microsoft Service servers with all other Power BI Pro licence users in your geographic area.
When a Pro licence schedules 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 that have Pro licences. Manual refreshes are not queued but run straight away, so they appear to take less time.
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
Thanks, this is pretty much the answer I'm looking for. We have a few users on premium per user, but too many contributors who only have pro licenses for the premium workspace solution in this case.