Azure cost managment API returns wrong value

Question

Hi,
I am working on getting the daily billing from API, but I noticed that sometimes I get the wrong value.
Here is my correct usage:

And here is what I get sometimes when switching to Group by Meter category

The values are multiplied for some reason.
I tested the API overnight and got the multiplied value 18 times out of 267 between the hours 19:32 and 23:58.
The API I used is:
POST https://management.azure.com/subscriptions/<sub_id>/providers/Microsoft.CostManagement/query?api-version=2021-10-01
with the body:
{"type":"ActualCost","dataSet":{"granularity":"Daily","aggregation":{"totalCost":{"name":"Cost","function":"Sum"}},"sorting":[{"direction":"ascending","name":"UsageDate"}],"grouping":[{"type":"Dimension","name":"MeterCategory"},{"type":"Dimension","name":"PublisherType"},{"type":"Dimension","name":"ChargeType"}]},"timeframe":"Custom","timePeriod":{"from":"2022-07-25T00:00:00+00:00","to":"2022-07-25T23:59:59+00:00"}}

Please advise if this is a normal behavior.
Thank you

Answer 1

Hello @Lily Sorry for the inconvenience this must have caused!

Thanks for sharing the screenshots. This looks like “doubling”. We request ids and relevant details to investigate this issue further. Please file a support request with cost-management support team to look into this.

Here is the link - https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request to create support case.

FYI: Azure Cost Management support is included in the Basic Support Plan without any charge.
https://azure.microsoft.com/en-us/support/plans/

----------------------------------------------------------------------------------------------------------------------

If the response helped, do "Accept Answer" and up-vote it