Issues with the PowerBI Cost summary report

[IlKaizen]

Hi there,

I have some issue with the Cost summary report https://learn.microsoft.com/en-us/cloud-computing/finops/toolkit/power-bi/cost-summary.
In particular I have issues with the Reservation and Saving Plans and how are they displayed in the report.
I have created an automatic export and as a data set I am using the "Cost and usage (FOCUS)". The exports are saved in a storage account Data Lake Gen 2. I am able to connect and load the data from the storage account.

Now, in my subscription I have both Reservations and Savings Plans, and in the PowerBI report in all the tabs I see this for "Total Savings" and "ESR"

In the Purchases Tab I dont see anything at all

Am I missing somethings or doing something wrong?
I really cannot figure out why I am not seeing any info about my Reservations and/or Savings Plan?

Thank you for your time and assistance,
BR
Mike

[flanakin]

A few thoughts:

• Do you have an EA or MCA account?
• If EA, did you export from the billing account? If not, savings won't be accurate. (Although, I don't think that's what you're seeing.)
• If EA, are you using Cost Management allocation rules? When enabled, you won't see reservation savings (but you should see savings plan savings).
• If MCA, you won't see reservation savings (but you should see savings plan savings).
• If MCA, did you export from the billing profile? If not, you won't see purchases.
• What months did you export? Did you make any purchases during those months?
  • I suspect the empty purchases page is because the purchases were from an older month, but that's just a guess.

If you're running into one of the cases where you can't see reservation savings, export the price sheet for all the months where you've exported costs and then enabled the experimental feature to populate missing prices in Power BI. If you run into any performance issues, I would recommend switching to FinOps hubs with Data Explorer. You will find immensely better performance and no more struggling with data refreshes.