The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Question still remains
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
53 | |
22 | |
11 | |
10 | |
9 |
User | Count |
---|---|
112 | |
32 | |
28 | |
18 | |
18 |