microsoft
Data in Rate Optimization Report are loading fine except Reservations tab ( currently empty with no errors )
🐛 Problem
TODO: MCA Customer has deployed finopshub v0.11, and billing admin tried loading up rate optimization report, all the tabs are loading fine except reservations. There's no errors reported but the data is empty
👣 Repro steps
TODO: Add repro steps below:
- Go to Workload optimization.pbit
- Click on Reservations tab
- No data reported.
🤔 Expected
TODO: All the other reports like cost summary are loading ok, where-as reservations are loading with empty data.
📷 Screenshots
TODO: Attached is the screenshot with empty data loaded
ℹ️ Additional context
TODO:
🙋♀️ Ask for the community
We could use your help:
- Please vote this issue up (👍) to prioritize it.
- Leave comments to help us solidify the vision.
Hi @sharmilamusunuru
Which exports did you configure? Being a MCA the exports need to be set up manually at the Billing Profile level so that you can create the required PriceSheet and Reservation Recommendation exports. We need that data so we can show the correct pricing, coverage, etc.
Hi @MSBrett , Focus reports are created manually at Billing profile, does the one-time export at billing profile won't include reservation recommendation data ?
Hi @MSBrett , Focus reports are created manually at Billing profile, does the one-time export at billing profile won't include reservation recommendation data ?
Nope, it's just focus data. You'll need to backdate everything.
Hi @MSBrett Price sheet, Reservation recommendations are loaded, but there are data discrepancies observed in prices in both cost summary, rate optimization reports too.
Hi, @flanakin @MSBrett has responded that It’s a bug in how PBI handles aggregation through an email. However, looking forward for clarity around whether the start and end date type has to adjust here as "date" or "date/time/timezone" like below ?