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.
