Share via

Duplicate data from Cost Analysis Export

kosmos 246 Reputation points
2023-05-31T15:24:52.3366667+00:00

I created daily Cost Management Export following the Azure tutorial.

I am getting loads of duplicate data. If the rows are exactly the same, it is fine, I just deduplicate it. Easy.

The problem arises when the duplicate data is due to different dimensions. Let me put some examples:

CASE 1: Different Resource Groups have the same data

Resourcegroupname, Costinbillingcurrency

resoucegroupABC: 6.519672205369674€

resoucegroupDEF: 6.519672205369674€

What are the odds that two resources have the exact decimals ?

After checking the original Azure Cost Analysis tool, only one of them is correct, the other one has different numbers.

Why is this happenning ?

CASE 2: Locations have wrong data

Data from the export only matches one Location. Example:

Correct number in the Cost Analysis tool --> 100€

Export csv --> 190€, but if filtered by 'EU West' then it is 100€

I tried removing the rest of the locations, but when I do this, I miss a lot of data and the numbers do not match for other dimensions.

Am I understanding something wrong about how the data is exported ?

Thanks a lot in advance!

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
3,577 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. kosmos 246 Reputation points
    2023-06-06T07:08:43.8166667+00:00

    I contacted Azure Support and they solved the issue. The reason is the pricing for the resources is the same and only one unit was consumed, therefore same decimals

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.