Exporting complete data for Fabric Capacity Metrics Interactive operations for Time Range

[FarhanJeelani]

Hi Community,

Does anyone know how I can extract the complete data from the Fabric Capacity Metrics reports for Interactive operations across the full Time Range?

Currently, I can only drill through for specific time ranges, but I'd like to see the total number of requests made each day and month. Is there a way to accomplish this?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @FarhanJeelani 

In the blog linked below, it shares how to extract data from Fabric Capacity Metrics App using DAX Studio and SQL Server Profiler tools. I hope you find it helpful.

How to extract data from the Fabric Metrics App – Part 1 – PBI Guy

Here is a similar solved case for your reference:

Solved: How to Download the Fabric Capacity Metrics Data - Microsoft Fabric Community

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rubayatyasmin]

Hi, @FarhanJeelani 

did you try creating custom report from the semantic model? that way you can add measure for total requests.