🐛 Problem

We have setup the finops toolkit and also using powerbi report setup the cost summary, governance, rate optimization report for our azure tenant. After the creation of rate optimization we noticed that there is no savings from RIs being calculated as we didn't exported the prices yet. We exported the price yet and noticed that the savings calculated is still 0 even though we have signitifcant amount of central reservation being used in the tenant.
We noticed that the ContractedCost and ListCost is 0 in the Focus cost export when central reservation applies to the resource which is fine. But when we use KQL to find the ContractedCost, ListCost and EffectiveCost for the Commitment discount type is Reservation then all these cost are same.

KQL query being used

Costs_final_v1_2
| where BillingPeriodStart between ((now() - 90d) .. now())
| extend Period = extract(@"(\d{4}-\d{2}-\d{2})", 1, tostring(BillingPeriodStart))
| where Period == "2025-08-01"
| where CommitmentDiscountType == "Reservation"
| project EffectiveCost, ContractedCost, ListCost

👣 Repro steps

TODO: Add repro steps below:

1. Go to
2. Click on
3. Scroll down to
4. See error

Ingest Focus Cost export and then ingest Prices export to the msexports in the storage account. After the ADX pipeline runs, then setup the Rate Optimization workbook.
In the ingestion database use the KQL which i provided and see if the price for reservation is same for column contractedcost, effectivecost and listcost or not. As that should help in calculating the discount from savings.

🤔 Expected

TODO: Add a clear and concise description of what you expected to happen.

ContractedCost and Effective cost should be different in the ingestion database in order to calculate savings. Right now its same so it shows savings as 0. 

We have indeed ingested Prices export and reservation export and triggered the ADX pipeline to get it ingested. What should we do in order to calculate the savings from the RIs?
Right now the effective cost is getting populated for contracted cost and list cost for reservation transaction which shows savings as 0. I also looked at the FOCUS cost export manually and for reservation transaction it shows 0 amount for contracted and list cost which is usually the case for reservation transaction.
Using above mentioned KQL you can see what we see in ingestion folder for reservation transactions below in screenshot

📷 Screenshots

TODO: If applicable, add screenshots to help explain your problem. Remove if not applicable.

Snippet from the KQL report from ingestion database showing same cost

Snippet from the Rate Optimization report showing same cost report

ℹ️ Additional context

TODO: Add any other context about the problem here. Remove if not applicable.

Is there an issue in the transformation which is replicating the effective cost value to contracted cost instead of picking up contracted cost from the pricesheet?

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.