Enable savings calculations in Power BI reports for CSP customers

[hemanthmatam]

In the FinOps Power BI report for CSP customers, the Cost Summary section is displaying inconsistent and incorrect values in one of its charts.

Issue Details:

The Total Savings field shows seemingly random values.
The Effective Savings field remains at 0, even when the customer has purchased Reserved Instances (RIs).
This misrepresentation leads to confusion and inaccurate cost optimization insights for CSP customers.

Expected Behavior:

When RIs are purchased, both Total Savings and Effective Savings should reflect accurate and consistent values based on actual usage and reservation benefits.
The chart should correctly sum and display savings metrics without discrepancies.

Steps to Reproduce:
Open the FinOps Power BI report for a CSP customer with active Reserved Instances.
Navigate to the Cost Summary section.
Observe the values in the Total Savings and Effective Savings fields.

Impact:
Misleading financial insights for CSP customers.
Potential miscommunication in cost optimization assessments.
Reduced trust in the accuracy of FinOps reporting.

Suggested Fix:
Review and correct the logic used to calculate and display Total Savings and Effective Savings.
Ensure alignment with RI purchase data and actual usage metrics.

[flanakin]

To clarify, this is a known limitation with Cost Management data. It's not a bug in the toolkit.

We can track this as a feature request to add the retail price sheet API and use that since CSP subscriptions don't have access to the price sheet from Cost Management. I would also encourage you to push this feature request directly with the Cost Management team to avoid the need for a workaround.

In the meantime, @RolandKrummenacher already does this in his extension to FinOps hubs. He makes this available to his customers as part of his company's cost optimization service offerings.