Is cost management data export having different fields for different account types?

Lukasz Opasiak 21 Reputation points
2021-10-06T11:16:09.153+00:00

Hi.
Using https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/tutorial-export-acm-data?tabs=azure-portal I've created automatic daily export of my cost data. Everything works fine, but the example at the bottom of the tutorial is having fields I don't see on my file.
Are the export CSV columns different for different account type (EA, PAYG, MCA) ? If yes, where can I find the expected columns for each of types? I found the doc for MCA https://learn.microsoft.com/en-us/azure/cost-management-billing/manage/mca-understand-pricesheet, but I cannot find one neither for PAYG and EA.

Thanks.

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,007 questions
0 comments
Accepted answer
  1. Monalla-MSFT 11,551 Reputation points
    2021-10-06T15:58:19.297+00:00

    Hello @Lukasz Opasiak - Thanks for reaching out.

    Yes, the terms are different for different account types.

    Please take a look at the below docs for more info :

    1. Microsoft Partner Agreement
    2. PayG and EA

    Exports from Cost Management output the same information as what you get from a usage details file.

    Hope this helps.

    If the response helped, please feel free to "Accept as Answer" so it can be beneficial to the community.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukasz Opasiak 21 Reputation points
    2021-10-06T16:16:17.347+00:00

    Hey thanks for the quick response.
    The second link seems to be broken, so if you could update it, I'd be grateful.

    Cheers.

  2. Francesco Mantovani 11 Reputation points
    2023-07-04T12:12:25.8133333+00:00

    Not only.

    If you switch Microsoft Azure Consumption Commitment (MACC) you might find yourself in the situation in which:

    • The order of the column has been altered
    • More columns are added
    • Several columns have been renamed

    In my case the columns renamed were:

    • productId --> ProductId
    • product --> ProductName
    • subscriptionId --> SubscriptionId
    • resourceId --> ResourceId
    • payGPrice --> PayGPrice

    And they completely changed the behave of my Power BI. the only solution was to rename the columns of all the CSV of the old MACC and make them match the new MACC.

    Crazy!

    0 comments