microsoft / microsoft/finops-toolkit

Credits are not included in Power BI reports

Open
#875 3 comments 2 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Help wanted ✨ Skill: Data factory Tool: FinOps hubs Type: Feature 💎
Dominant language
PowerShell
Stars
603
Forks
248
Avg merge
7d 11h
Merged PRs (30d)
11

Description

🐛 Problem

When comparing the invoices to the Power BI report CostSummary, we found a significant deviation several months. It seems to be related to missing credits in the Power BI report. So far for 2024, the deviation was more than 100.000 EURO. I have made a comparison for all the months in 2024 and we see the same pattern

👣 Repro steps

  1. Go to Cost Management view in Azure Portal and look at your invoices
  2. Click on one invoice for comparison
  3. Then open the Cost Summary Power Bi report
  4. Select Summary and use the same time period as for the invoice

🤔 Expected

I hope this can be included in the Power BI Report to ensure we have the same numbers on our invoices as in the Power Bi Report

📷 Screenshots

I have added one screenshot of the invoice from March and one screenshot from the Power Bi report
Invoice March 2024
Screenshot Cost Summary Power Bi report

🙋‍♀️ 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 by reproducing the 2024 comparison from the Azure Cost Management invoice and the Cost Summary Power BI report, using the matching time period described in the issue. Trace where credits are omitted and verify the report totals match the invoice amounts before considering the issue done.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure
Domain
analytics, cloud
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.