Premium P1

[IF]

Hi,

I know the Premium P1 can refresh dataset/dataflows every 30 minutes. However, it can update them if the update time will not exceed 180 minutes. Of course, it is not going to stop after half an hour continues for a while, but it is also possible that there are some other datasets in the coming time slots. I wonder if the P2 or P3 has a max of 180 minutes every half an hour or it is also doubled to 360 minutes. 

Thanks in advance

[GilbertQ]

Hi @IF 

If you have to upgrade your Premium P1 to Gen2, the refreshes will not count against your current datasets and they should be able to be refreshed quicker?

[jeffshieldsdev]

---

@GilbertQ wrote:

Hi @IF 

If you have to upgrade your Premium P1 to Gen2, the refreshes will not count against your current datasets and they should be able to be refreshed quicker?

---

I've been piloting Gen2 this week and am getting spikes of 300% capacity utilization!  Gen2 will not be an option for me until I harvest some of my larger datasets in favor of smaller more focused ones.

[jeffshieldsdev]

On P1 you can't have up to 6 concurrent refreshes. I think the timeout is 6 hours for datasets.

edit: this says 5 hour timeout but I thought it was 6 https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios#sch...

[IF]

Thanks for the explanation. Do the concurrent refreshes change after upgrading to P2 or P3? Now it is 6 concurrent refreshes for every 30 minutes, which is 180 minutes per half an hour.

[jeffshieldsdev · Accepted solution]

What do you mean by "every 30 minutes, which is 180 minutes per half an hour"?  You can have 6 concurrent refreshes, a dataset can be refreshed at most every 30 minutes, the refresh timeout is 5 hours.

"the supported number of maximum concurrent refreshes is set to 1.5 times the backend v-cores, rounded up."

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-capacity-optimize#why-are-refreshes-...

[IF]

For example; P2 has 16 v-cores and 8 Backend Cores. In this case, the maximum concurrent refresh could be 8x1,5=12 times. It enables 12 times x 30 minutes =360 minutes of available slots to refresh data for the scheduled updates of the apps/dataflows. If I understand correctly, P2 has doubled performance when compared to P1.