[External][Cost Management] ListCost missing in Cost Management exports

[flanakin]

🐛 Problem

Microsoft Cost Management does not include ListCost and ListUnitPrice in all exported cost data. There are 2 bugs with this:

1. ListCost and ListUnitPrice should always be specified.
2. If not available, ListCost and ListUnitPrice should be null and not 0.

This is documented in Ingest cost details data as a limitations for PayGPrice column in actual/amortized cost data. This limitation also applies to the ListCost and ListUnitPrice columns in FOCUS data.

👣 Repro steps

1. Export FOCUS cost data.
2. Filter rows where ListCost == 0 and ContractedCost > 0.

🤔 Expected

• All rows should have an accurate ListCost and ListUnitPrice values.
• The only records with a ListCost or ListUnitPrice of 0 should be free.
• If a value is not available, they should be null. (However, ListCost and ListUnitPrice should always be available.)

ℹ️ Additional context

This is a tracking bug only. The FinOps toolkit community is not responsible for this and cannot resolve the issue. Subscribe to this issue to be notified when the issue has been resolved.

We are tracking the following workarounds until this issue is resolved:

• [Power BI] Calculate partial savings when ListCost/ContractedCost is not available #835
• [Power BI] Join cost/pricesheet to populate ListUnitPrice and ListCost when missing #615

Related issues:

• FOCUS gaps in Cost Management exports #834
• ListCost calculation not correct #727

Note

If you are facing this issue, you can file a support request with the Cost Management team to convey the importance of these columns for your needs; however, as a known issue, the support request will likely be closed. The intent of creating a support request is to raise awareness of your needs and increase the priority of the fix.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Let us know if you see an opportunity to improve the experience from the toolkit.

[flanakin]

A workaround for this Cost Management data gap is available in 0.8 Power BI reports and FinOps hubs 0.7+ with Data Explorer. We'll keep this issue to track the Cost Management data gap, but please note it no longer applies to FinOps toolkit solutions. If you notice any issues, please create a new issue.