Gen2 Metrics App: Analyze in Excel help

[Anonymous]

So Im not even sure if its possible to achieve what im attempting but here we go!

So my underlying goal is to get a unified metric for all of my Capacities from the Gen2 Metric App. The desired "Unified Capacity" metric is the 14 day Artifact Dataset thats commonly found on the bottom left of the Gen2 Metrics App Overview page.

It seems that my best chance of achieving this is to export this data to Excel using the Analyze in Excel feature and then try to get a unified Pivot table going. 

Any thoughts/guides is appreciated!

[v-easonf-msft]

Hi, @Anonymous 

I haven't tried, but it does sound like a workable solution.

You can check if XMLA end point can be used to query Gen2 Metrics App.

Dataset connectivity with the XMLA endpoint 

Querying Premium Capacity Health Metrics Using XMLA End Point 

Best Regards,
Community Support Team _ Eason