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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
rdlhrvy
New Member

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

3 REPLIES 3
AndyDDC
Solution Sage
Solution Sage

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 

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 .

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.