Recommended CPU usage for a premium capacity?

[TCPBI3]

For example, say I have a Premium Capacity in Power BI. P3 with 32 V-Cores. How much CPU(s) in a weekly timeframe should I be using on that capacity to maintain an optimal performance? I have been searching for a CPU(s)/V-Core ratio that is reccommended but I cannot find anything and Microsoft support has not been able to answer either. I believe this would be beneficial information just for overall capacity planing & management.

The data has to be out there as you can see the CPU(s) listed on the Capacity Metrics report. Has anyone else had this curiousity before and if you have a ratio that is working optimally for you please share.

[TCPBI3]

Thanks Gilbert, I understand that. I am mainly trying to avoid an overloading scenario when attempting to consolidate resources. I figured there would not be an ideal number but it was worth the ask. I appreciate the response.

[GilbertQ · Accepted solution]

Hi @TCPBI3 

The reason that I think no one has put the details out there is because everyone's datasets are different. The way the datasets are modeled is different. As well as how the DAX measures are created. All of that will affect the CPU performance.

What I would say is as long as you are within your CPU usage and it is working well that is a good sign. Quite often there are ways to optimize the dataset or measures. That can depend on a whole host of things. And typically it would require someone with a lot of experience in tabular modelling and DAX.