microsoft / microsoft/finops-toolkit

Reservation information not displaying in reports

Open
#1,663 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Resolution: External Tool: Cost Management Tool: Power BI
Dominant language
PowerShell
Stars
603
Forks
249
Avg merge
7d 11h
Merged PRs (30d)
11

Description

🐛 Problem

Reservation information not displaying in Power BI KQL reports for MCA account

👣 Repro steps

CostSummary KQL Power BI Report

  1. Click on Inventory Page
  2. Select Date Range for MCA data
  3. Click Commitment Discount and unselect everything except for Reservation
  4. Review Total Savings and ESR items at the top of report

RateOptimization KQL Power BI Report

  1. Click on Commitments page
  2. Select Date range for MCA data
  3. Review Commitment savings and ESR columns

🤔 Expected

Reservation savings data populated for date range of our MCA billing profile.

ℹ️ Additional context

From the Rate Optimization report, we do see Savings Plan data in the Commitment savings column for the MCA account date range. We migrated from an EA to MCA and have both sets of data ingested into Fabric as a primary data store. When reviewing date ranges during our EA, we do see both Reservation and Savings Plan data.

The Fabric Real-time dashboard does show data in the Effective cost breakdown by month section, with both Reservation and Savings Plan columns, for the MCA in the 2025-05 Month.

I've tested v0.11 and v0.10 reports using v0.11 Hub

🙋‍♀️ Ask for the community

We could use your help:

  1. Please vote this issue up (👍) to prioritize it.
  2. Leave comments to help us solidify the vision.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the CostSummary and RateOptimization KQL Power BI reports and review how MCA reservation data is populated for the specified date range. Compare their Reservation and ESR results with the Fabric Real-time dashboard and the EA-period results; done means reservation savings appear in the report totals and columns.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure
Domain
analytics, data
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.