Forum Discussion
Solved
Power BI Slow Report Performance - Service
Dear Community, I hope you're doing well! I'd like to ask about PBI Slow report performance in Service. First of all, I'm sorry I can't show you the table visual since it contains confidential...
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?
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.