Forum Discussion
Quiny_Harl
Advocate III
Advocate IIIHow to find which interactive operations account for the CPU consumption?
Hi folks, I have a Power BI report that generates significant CPU consumption and it accounts for a big portion of the whole premium capacity consumption. As a result, the capacity becomes throttl...
lbendlin
Super User
Super UserThe obvious but very expensive answer is to use Azure Log Analytics on the workspace that you suspect of hosting the offending queries.
Capacity Metrics doesn't go down to query level.
Try to isolate the user causing the CUs and watch them use the report.
Quiny_Harllbendlin, thanks for your input.
Do you mind explaining why the Azure Log Analytics solution is so expensive and how would that work?