Forum Discussion
Capacity Metrics Report - Timepoint Details - Operations Question
Hello!
I need some assistance understanding something in the Capacity Metrics report. We have had a few spikes over 100%, and when I look at the timepoint detail for those, this is an example of what I see:
Just outside the screenshot, I see that for this one item, Query at this timepoint is consuming a siginificant percentage of the base capacity. I want to work with the report developer to assist them in optimizing their report to eliminate the cause of this overage.
What I need help with is how to direct them on identifying possible causes. Based on what I understood so far, "Query" means "Queries initiated by an on-demand data request from a user. For example, loading a model when opening a report, or user interaction with a report." I opened the report myself to test performance, and the report loads quickly, interactions with the visuals are quick and responsive. So it appears to me that loading a model when opening the report or user interaction with the report are not consuimg much CU.
What could I be missing here?
Thank you!
7 Replies
Based on user feedback (visuals rendering slowly) the developer needs to identify measures that perform poorly. These measures then need to be refactored. Goal should be a visual rendering time under 5 seconds.
There has been no feedback from users on slowly rendering visuals, and I just tried it myself again--the report fully rendered in 3 seconds.
This suggests to me one of three possibilities:
- Whatever is being captured in the Capacity Metrics as shown in the screenshot may be something other than what Microsoft defined Query to mean in their documentation. If it is this, how do I figure out what is really being captured and reported here?
- It rendered very slowly when it was opened at the time shown in the screenshot for some reason but typically renders fine, as was the case when I opened it. If it is this, how do I figure out what contributing factors there might be?
- Something else is happening that I haven't thought of or considered.
Does the User column say "Power BI Service" or does it list an actual user?
