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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Gow_tham
Frequent Visitor

Fabric Capacity Metrics

We've been experiencing capacity throttling for the past month. Upon analyzing the capacity metrics app, we found that it was caused by a single user on a particular report. However, this report has 7 pages, and the semantic model is an enterprise reporting model with many downstream reports (around 30 odd key reports). Is there a way to identify the specific query that the user is running on the report that's causing the throttling?

PS: We've used the activity logs but couldn't get the query details from them. We can see the report and other details but not the query info. 


@lbendlin  Can you help with this ?

2 REPLIES 2
v-jtian-msft
Community Support
Community Support

Hello,rajendraongole1 ,thanks for your concern about this issue.
And I would like to share some additional solutions below.


Hi,@Gow_tham .I am glad to help you.
Based on your description, you currently want to identify the specific query that is causing the capacity limit. And you have already located exactly which report is having the problem.
If your capacity limit issue might be due to the report runtime queries being too large and complex, I hope my suggestions below will help you.
You can try connecting to the report's pbix file using DAX Studio (Power BI Desktop)
Or connect to the semantic model in Power BI Service via XMLA endpoint.
PS: To use XMLA you need to have PPU/Premium capacity licence and above.
URL:

Power BI XMLA Endpoint - Step by Step Examples, How to Use? (excelmojo.com)

DAX Studio captures all DAX queries running on Power BI datasets. This helps identify which queries are consuming the most resources, thus identifying performance bottlenecks.
You can use DAX Studio's Server Timings and Query Plan features to analyse the execution time and resource usage of each query in detail. This helps to understand the specific performance issues in the problematic query.
I hope you find the following article helpful.
URL:
How to Use DAX Studio for Power BI | Hevo
Solved: real size of data model - Microsoft Fabric Community
Getting Connected | DAX Studio
 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rajendraongole1
Super User
Super User

Hi @Gow_tham - can you please check the following solved threads on the same issue.

Solved: Fabric Capacity Metrics - Microsoft Fabric Community

Solved: Fabric Capacity Metrics - Microsoft Fabric Community

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.