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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
rdlhrvy
Helper I
Helper I

Fabric Capacity Metrics (Operation - Query)

I am investigating the high CU consumptions against Capacity. Is there anyway to find out what query has been executed against the model or what interaction they are doing to the report? See picture that I wanted to find out what query has been executed that consumed too much in the capacity.

 

Screenshot 2023-12-04 120158.png

 

Thanks

4 REPLIES 4
AndyDDC
Super User
Super User

I don't know if there's anything directly in the fabric capacity metric apps that could help, however you could use profiler in a tool like sql server management Studio to connect to the workspace endpoint and capture analysis services events to pinpoint any issues with specific queries in the semantic model 

I only monitor it with DAX Studio but no luck identifying what is already executed from that timepoint if my Dax Studio is not running to capture the queries executed. I wish there's a way in fabric capacity to identify what query executed. It's easier to investigate why that query takes so long to execute

Anonymous
Not applicable

Hi @rdlhrvy ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered. Otherwise, will respond back with the more details and we will try to help .

Anonymous
Not applicable

Hi @rdlhrvy ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered. Otherwise, will respond back with the more details and we will try to help .

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!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!