cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cassidy
Resolver I
Resolver I

Knowing when to upgrade capacity

Hello,

 

Trying to gauge upgrading capacities based on other people's experiences. 

 

Our P1 Capacity hits 100% probably 2-3 times per day, sometimes it's a noticeable pattern, sometimes I don't understand it at all (like 9 p.m. at night when there are 0 refreshes and I'd expect 99% of Users to hopefully not be working).

 

Our largest Dataset is 1.9 gb pbix, which according to the recommendation, < 3 gb is still okay for P1.

 

Should I upgrade?  Should I go for enable Auto Scale?

 

I just don't know how normal it is to peak 100% several times a day, let me know.  Thank you

3 REPLIES 3
GilbertQ
Super User II
Super User II

Hi @cassidy 

 

It could be possible that then there is a lot of CPU activity from a dataset refresh, or if the dataset is not using the optimal star schema with complex DAX measures this can also consume a lot of CPU





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

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User II
Super User II

Hi @cassidy 


Could you have a look at upgrading your P1 capacity to Gen2?


The reason is that this could assist greatly with the performance of your P1 capacity.

 

Here are more details: Understanding Power BI Premium Gen2 (preview) - Power BI | Microsoft Docs





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

Proud to be a Super User!







Power BI Blog

Hi Gilbert,  I did switch it to Gen2 a while back.  Our refresh times decreased, but I haven't seen a decrease in hitting capacity.  The Utilization Metrics points to a few users with high Query utilization, so I'm working with them.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

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

Top Solution Authors