Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
AniBanani2020
Frequent Visitor

Fabric Capacity - How to trace background operation "Background Query"

Hello,

 

Question - how can i find where a background operation "Query" is hitting my semantic model? I am seeing significant background cpu usage from pure report consumers as well as powerbi report developers. Is it possible to figure out where this operation is occuring? How can i stop this from happening.

 

Unfortunately, Microsoft's documentation on operations are fairly limited. I am also unable to see refresh execution details via the api as they are scheduled refreshes.

 

Background query = "Queries for refreshing tiles and creating report snapshots"


Background
I have an large semantic model used across the enterprise. Analyts/Pbi developers leverage this to make their own thin reports and use as a base for their own semantic model (reference as a DQ). The semantic model uses incremental refresh and contains around 100mm row fact table. The model is also not set up for cache - although models derived from this model via DQ could be however, the population that i am seeing hit my background usage for this "query" operation are only 5-7 people where as the total consumer pool is well into the 100s.

 

Any advice is welcome. Appreciate the read

2 REPLIES 2
AniBanani2020
Frequent Visitor

Question still remains

AniBanani2020
Frequent Visitor

Update. Found the semantic model that a developer had built on top of this enterprise model. They had brought in more data, used a virtual relationship to join the table and had a report built out using this. Kicker was user had set his model to save cache. When i removed this, i no longer saw the background hit 24 hrs later.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.