topic Export CU Use API in Developer

Export CU Use API

SeattlePowerBI — Mon, 01 Apr 2024 15:37:53 GMT

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.

Re: Export CU Use API

lbendlin — Mon, 01 Apr 2024 19:20:51 GMT

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

Re: Export CU Use API

SeattlePowerBI — Mon, 01 Apr 2024 19:29:23 GMT

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.

Re: Export CU Use API

lbendlin — Mon, 01 Apr 2024 19:32:28 GMT

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