Report on Azure VM license

[GrahamRollerson]

HI everyone

Im putting together some reports using the Azure Billing data out of the EA portal but im having difficulty with one thing.

we have a mixture of Azure licensed VM's and Enterprise Agreement licenses VM's. I need to be able to idenfity these on a report so we can easily add the licenses to our EA true up in the summer. 

HAs anyone done this before? and if so can you help me out? i cant find a variable in the billing data to do it. 

thank you

[v-micsh-msft]

Hi @GrahamRollerson,

How do you connect to the Azure Billing data?

Through the Microsoft Azure Enterprise Content Pack, or connect to Azure Consumption Insights through Power BI Desktop?

You may take a try to connect to ACI through Power BI Desktop, which allows user to generate customized reports or visuals.

https://docs.microsoft.com/en-us/power-bi/desktop-connect-azure-consumption-insights

You may take a look at the

"

To help clarify, the following table provides a mapping between the API, the connector, and columns you see in the Azure Portal. Also indicated is whether the column is obsolete. For more information and definitions of these terms, take a look at the Azure billing data dictionary.

"

mentioned in the article above, to find the proper identifier which could be used to distinguish different VM licenses, then build a slicer based on that.

Regards,

Michael