Forum Discussion
Solved
Performance considerations pulling from a P1 Premium Capacity to a Power BI Pro Workspace
We have a P1 Premium Capacity and from Capacity Metrics app see that 3 interactive XMLA Read Operations are consuming ~50% each; total of 150% CU capacity. We suspect that it is a result of datasets...
What they are doing is likely Analyze in Excel, with excessive cube functions. Show them how to use DAX queries instead.
Hi YuenKelly
Even if the report runs from a Pro workspace, pulling data from a Premium dataset still consumes resources on the Premium side. This includes XMLA reads, DAX queries, or live connections—all of which use Premium's CU.
To reduce the load:
-
Review external tools hitting the dataset (e.g., Excel, Power BI Desktop, XMLA endpoints)
-
Consider restricting access to heavy users
-
Optimize large queries or refresh patterns where possible