flanakin / cost-management-powerbi

A set of Power BI reports for Microsoft Cost Management
MIT License
10 stars 3 forks source link

Not working for MCA #8

Open georgnesse opened 1 year ago

georgnesse commented 1 year ago

Hi,

The savings/commitment tabs are not working for MCA accounts. It seems like it is not able to calculate the "OnDemand - If no RI" cost.

image

Br, Georg Nesse

flanakin commented 1 year ago

The issue here is that Cost Management doesn't provide the data needed to show savings for MCA accounts. I would recommend raising a support request with Microsoft that reservation savings cannot be calculated with data coming from Cost Management exports or the Cost Details API. They won't be able to resolve it with a support request, but enough support requests will raise the priority so the responsible team will get it fixed.

In the meantime, I'll keep this open to add an explicit note about this into the report. It's not the first time it's come up and won't be the last.