Forum Discussion
100% Background CPU %
I wish I would of thought of that in the moment, we have since returned to normal Backend CPU %.
I did open a Support Ticket at the time as well, but they have not been able to give any insight outside of what the Capacity Utilization Metrics already show.
GilbertQ , if you happen to know, I was mostly paying attention to the below graph and I understood the Red as Users querying the Dataset and Blue as things like Refreshes of Datasets/Dataflows. If someone was excessively querying the Datasets, wouldn't the graph show Red pushing past 100%, while Blue stays stable/lower?
Interactive CPU - Red columns represent the number of CPU seconds used during interactive operations in a 30 second period.
Interactive operations cover a wide range of resources triggered by Power BI users. These operations are associated with interactive page loads.
Background - Blue columns represent the number of CPU seconds used during background operations in a 30 second period.
Background operations cover Power BI backend processes that are not directly triggered by users, such as data refreshes.
Hi cassidy
It could possibly be multiple dataset refreshes happening?
As far as I can recall the background operations are averaged over a 24 hour periods?
Here is the learn document: Power BI Premium Gen2 capacity load, overload, and autoscale - Power BI | Microsoft Learn
I would also have logging enabled to Log Analytics which would allow you to see if users are running queries and how long they are running for?