microsoft / finops-toolkit

Tools and resources to help you adopt and implement FinOps capabilities that automate and extend the Microsoft Cloud.
https://aka.ms/finops/toolkit
MIT License
275 stars 90 forks source link

RateOptimization dashboard is empty #919

Open simonarbel opened 3 weeks ago

simonarbel commented 3 weeks ago

Hello

Using the latest version of the hub (0.4). MCA customer with billing account admin privileges is trying to pull out data in the RateOptimization report, no error messages are shown during the refresh but report is empty. what could be the reason?

The CostSummary dashboard is working fine.

flanakin commented 3 weeks ago

Cost Management fixed a bug in FOCUS 1.0 exports in late July that was showing reservation usage as PricingCategory = "Standard", which gets filtered out of the Rate optimization report. That's the only issue I'm aware of.

To see if that's the issue, add a table to a new page that filters ChargeCategory = "Usage", CommitmentDiscountType <> null, and PricingCategory <> "Committed". Make sure there aren't any global or page filters on top of these. You shouldn't have any rows in this table.

Let us know if that's it. If not, we may need to hope on a call to get to the bottom of it.

FYI - If this is the issue, you can re-export the data to fix it. We also have a workaround for coming in 0.5 for those who haven't re-exported data.

flanakin commented 3 weeks ago

@allcontributors Please add simonarbel for bugs

allcontributors[bot] commented 3 weeks ago

@flanakin

I've put up a pull request to add @simonarbel! :tada: