Forum Discussion

amien's avatar
amien
Helper V
1 year ago

Fabric Capacity Metrics Data - Extracting data on User - CU level

is there another way to extract to user consumption on CU WITHOUT using a 30-second timepoint?   I have read all the examples, for example from PBIGuy (using DAX to TimePointInteractiveDetail). But...
Need Help
amien's avatar
amien
Helper V
1 year ago

Thanks for your answer .. perhaps you didn't read my full question? I know the PBI Guy option .. but the 30 second timeframe need to extract the data is just not feasable if you want to extract one day of data. You need to fire like 1800 DAX queries to get a full day. And then need to loop through all the capacities. Do you have an alternative to avoud the 30 second timeframe?

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi amien ,

    Extracting a full day's worth of data using those 30-second intervals is definitely not practical, especially when you're dealing with multiple capacities and users. I completely understand how frustrating that can be.

    Unfortunately, at this time, there isn’t a built-in or officially supported way to get daily-level user CU consumption without relying on the TimePointInteractiveDetail granularity. I know it’s not ideal.

     

    It might be worth raising a support ticket with Microsoft. They may be able to advise if there are any internal tools, APIs in preview, or workarounds suited to your scenario.

    Please refer below link on how to raise a contact support or support ticket. 
    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 
     

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

    Best Regards, 
    Community Support Team