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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

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. 

 

_PowerBI_forum_question.JPG

 

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous ,

Please review the following documentation and check if that is what you want.

Learn about Direct Lake in Power BI and Microsoft Fabric - Power BI | Microsoft Learn

Best Regards

Anonymous
Not applicable

Hmm. Not sure what the relevance of Fabric DL is to this question (on the Capacity Metrics App). 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors