Using Azure Cost Management (Usage Details) table in PowerBI - What column to use as Unique Key?

Connor A 0 Reputation points
2023-10-11T20:33:54.8133333+00:00

Hey all,

I have been playing around with the Azure Cost Management data for my company imported into PowerBI. I cant seem to determine which column would work best as the Unique Key (unique for each record). I need a key in order to accomplish some model mapping I am trying to do.

It appears as though all of the columns have duplicates and therefore I don't appear to have any column with unique values. Is there no default unique key column in Azure Cost Management Usage Details table?

Or perhaps I am missing it? Any help would be appreciated.

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,355 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ryan Hill 27,111 Reputation points Microsoft Employee
    2023-10-18T00:35:23.4666667+00:00

    Hello @Connor A

    I know you can create a new calculated column that combines multiple columns to create the unique key using Power BI data transform. However, I have reached out to the product team for any suggestions/insights. Once I get any insights, I'll update my answer.


    EDIT 18 October 2023 See Understand usage details fields - Microsoft Cost Management | Microsoft Learn, you'll notice that there are some columns flagged with a 1. You can use these fields to build a composite key.

    ¹ Fields used to build a unique ID for a single cost record. Every record in your cost details file should be considered unique.

    0 comments No comments