Fabric Capacity Metrics App - User CU Analysis

[jbauer22]

Is there a way to look at CU usage by User and then Operation for the last 14 days?  I would like to determine what user(s) are consuming the most CUs and then analyze what operations they are performing (in the last 14 days).  The Fabric Capacity Metrics App / Semantic model only seems to allow you to look at a Timepoint which is a very small window of the day.

[v-ssriganesh]

Hi @jbauer22,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh · Accepted solution]

Hi @jbauer22,

Thank you for reaching out to the community forum with your query.

The Fabric Capacity Metrics App itself doesn't provide a direct way to view CU usage by User and then Operation for the last 14 days. The Timepoint view is indeed limited in its scope. However, Azure Monitor Logs can be utilized to achieve this. This tool enables querying detailed resource usage information. By writing Kusto Query Language (KQL) queries, you can: Filter for the last 14 days, Group by User and Operation, Calculate the total CU consumption, and visualize the results using log analytics features.

For more detailed guidance on how to use Azure Monitor Logs and write KQL queries, you can refer to the official Microsoft documentation links below:
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-query-overview

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/get-started-queries

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.