cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IF
Post Partisan
Post Partisan

Premium P1

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

1 ACCEPTED SOLUTION
jeffshieldsdev
Impactful Individual
Impactful Individual

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-...

View solution in original post

6 REPLIES 6
GilbertQ
Super User II
Super User II

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog


@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
Impactful Individual
Impactful Individual

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...

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
Impactful Individual
Impactful Individual

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-...

View solution in original post

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.

 

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.