Fabric Capacity Metrics

[Gow_tham]

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 ?

[Anonymous]

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]

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