Forum Discussion
Power BI Slow Report Performance - Service
Have a look into the capacity metric, see if you can identify any processes that take significantly long or it could also be throttling on your capacity if it hits the limit?
Thanks rajendraongole1 , for your feedback!
As I mentioned, I've tested my DAX Query for "table creation" using DAX studio by clearing the cache as shown in the image above. The largest number of duration time came from the Table. That's why I confuse our users have taken long while (around 15-40 seconds) to load the table. For the visuals, I use the native rather than the custom one. On that page, I have 1 Slicer, 2 text boxes, 1 bookmark navigator, and 1 table. So, I'm not sure if it necessary to reduce number of visuals again 🙂
On that table, I have 9 fields. 2 among them are column field from dimension table. While the rest are measures.
Our workspace also using premium capacities as shown in the image below.
Furthermore, your recommendation about dataset storage movement and Gateway Cluster are interesting. Have you ever done it before? are they difficult to be done?
Have a look into the capacity metric, see if you can identify any processes that take significantly long or it could also be throttling on your capacity if it hits the limit?
- Thanks Tutu_in_YYC, for your reply! Since I'm not a capacity admin, I tried to reach out someone who has access to capacity metric to see how our workspace behave. I've been showed the graph and it seems that the capacity is constantly overloaded. Lately, Background% achieve the %CU limit. Since our workspace is assigned to the regional capacity, i don't know how to solve the issue. Because scaling up the capacity requires approval from higher level.
If your report doesnt require high compute nor it is huge size wise, you can try removing premium capacity from the workspace, and just use the shared capacity.