Report Slow even with 2 Premium Capacities

Hi Anonymous 

My guessing is that there is a DAX measure or maybe relationships that need some attentions.

Download the pbix ans start tunning it. You can use DAX studio and Vertipaq analyzer or the performance analyzer

Hi Anonymous ,

The powerbi website has a more detailed troubleshooting process for slow report loading:

When reports are hosted on Premium Capacity, use the Microsoft Constructed Capacity Metrics application to determine if report hosting capacity frequently exceeds capacity resources. When resources are under pressure, it may be time to manage or expand capacity (Flowchart Terminator 1). When sufficient resources are available, investigate capacity activity during typical report usage (flowchart terminator 2).

For more details, you can read below document:

Troubleshoot report performance in Power BI - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.