Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Identifying Visuals and DAX Queries Causing Spikes in CU% Using Fabric Premium Capacity App

  • I'm using the new Fabric Premium Capacity App to monitor our Premium Capacity tenant. Recently, I noticed a significant spike in Capacity Units (CU%), which I've traced to interactive queries. (see screenshot below).
  • From the "CU% over time" visual in the report, I could drill down to see the specific report/dataset causing the overload.
  • I can see for example, a single query consumed 49% of our P2 capacity for an hour before failing (see screenshot).
  • I've identified the Report/Dataset and user from the "Interactive operations for Timerange" table (see screenshot ).
  • I now need to pinpoint the exact visual and DAX query responsible for this spike. This information is key for investigating and optimizing the DAX query.
  • QUESTION : Is there a way to directly identify the problematic visual and DAX query from within the Fabric Premium Capacity Reporting tools? 
  • I am aware the "Performance Analyser" tool inside Power BI Desktop could do this, but also requires downloading the PBIX from the service, and sequentially running the analyser on each report page. 

 

 

Need Help