Reservation Commitment Discounts showing zero savings in ADX Dashboard

[lawlormt]

Hi - I've just deployed the latest FinOps hubs 13.0. I'm primarily interested in looking at reservation commitment savings. I've exported a couple of months data but unfortunately the ADX rate optimization dashboard shows zero savings. We are an MCA customer and I know there are some known issues due to FOCUS export gaps (e.g. #835, #874, #614) but I thought workarounds had been implemented using data from the price sheet (which I also exported).
I see a data quality report is included in the ADX dashboard (screenshot below) but I'm struggling to interpret these! Are these the same old Focus export data issues and are the workarounds not helping here? Or is there something else I've missed? Any help, suggestions, advice appreciated!
Thanks
Michael

[flanakin]

@lawlormt Just to cover the most obvious thing, have you exported the prices? In order for FinOps hubs to populate missing prices, you also need to export your price sheet. Once the prices are ingested, the next cost ingestion should populate the missing prices. We are aware of a potential issue where the data may not be getting populated, but we don't know how expansive that is. Most of us don't have an account to be able to debug and test this for MCA, which also makes it a bit challenging.

[lawlormt]

@flanakin thanks for getting back to me. Yes absolutely the price sheets were exported. One thing I cant say for sure in what order, would sequence matter, would the price sheets have to be exported for a given month before the focus data export? Thanks

[josesarsa]

Export the price sheet first and then the cost

[francesco1119]

@lawlormt , can you check if this has started in April?

[francesco1119]

Something has definitely changed starting from April.
As you can see Reserved Instance is showing 0.00 for all the 3 meter Categories.

Savings Plans looks unaffected.

I've opened a ticket with Azure and the almighty Darshit Shah is helping. I feel I'm in good hands.

[lawlormt]

@josesarsa exporting the price sheet first makes no difference. I re deployed and exported all the price sheets first and then the usage. Same result. I'm not sure this could be a hard requirement anyway as I don't think you can create this sequencing/dependency when the exports are scheduled e.g. on a monthly basis.
@francesco1119 for me this has not started recently I also looked at this last year and the same issue was present. So I dont know if it is a bug or something I am doing incorrect.
@flanakin any suggestions to further troubleshoot? Is there anything I can do/check/provide that might help identify the issue?
Thanks
Michael

[francesco1119]

After investigation it turns out that the problem is the column x_CommitmentDiscountSavings not being populated in the FinOps Hub starting from April.
But... this problem will auto-resolve at the 18th of the month, because that day, is when we buy Reserved Instances and Savings Plans.

The problem is that:

• 👍 Negotiated savings: it's the ACD, column created by the FinOps Hub, is calculated for every day
• ⛔ RI Savings: It's the Reserved Instances, created by me, I couldn't find anything on the FinOps Hub

RI Savings = 
    CALCULATE(
        SUMX(Costs, Costs[x_CommitmentDiscountSavings] * Costs[x_BillingExchangeRate]),
        Costs[CommitmentDiscountType] = "Reservation"
    )

**### Is not calculated for every day!**  👈  As you can see from the picture it's the bump on the 18th of March 🙅 

• 👍 Commitment savings: it's the Savings Plans, column created by the FinOps Hub, is calculated for every day

So this problem will probably be resolved after the 18th of each month.
But this is a problem that exits. I cannot present dashboards like this to the board.
The solution is to find a way to show the Reserved Instance on a line like we do for ACD and SP.

Any idea how to?

[francesco1119]

Also, query used for debugging:

Costs_final_v1_2
| where BillingPeriodStart == datetime("2026-03-01")
| where CommitmentDiscountType == "Reservation"
| where ChargeCategory == "Purchase"
| summarize by x_ServicePeriodStart, ContractedUnitPrice, ListUnitPrice, x_BilledUnitPrice, x_EffectiveUnitPrice, x_CommitmentDiscountSavings, x_SkuOrderName, ChargeCategory

[francesco1119]

Fixed,

I had to:

1. Setup an Azure Export for the Pricesheet (must be version 2023 not 2024)
2. Upgrade the FinOps Toolkit to 13.0
3. Run Pricesheet export
4. Re-run ADF pipelines

And now it's fixed.