Forum Discussion
Gen2 Metrics App: Analyze in Excel help
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!
1 Reply
- v-easonf-msft
Community Support
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
