Export CU Use API

[SeattlePowerBI]

Is there a good resource on how to obtain CU use for reports and each action in the premium capacity? I need to develop a report for recovering cost of the capacity, and want to base it on CU's used. Hoping for a month of data.

[SeattlePowerBI]

Hello - yep I am aware of the capacity metrics app. It only keeps two weeks worth of data. So I need to design a process to extract data from its semantic model ever two weeks. Also, trying to export the data from my capacity via a power query drains my capacity of the CUs.. It would be cool if I could just use a script to export this from the API or if there was something better than the two weeks worth of data in the semantic model.

[lbendlin]

It's as if Microsoft is actively trying to prevent you from doing this.  I know, weird...

[lbendlin]

What is the Microsoft Fabric Capacity Metrics app? - Microsoft Fabric | Microsoft Learn