microsoft / microsoft/finops-toolkit
Credits are not included in Power BI reports
Nobody has claimed this yet.
- 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
- Go to Cost Management view in Azure Portal and look at your invoices
- Click on one invoice for comparison
- Then open the Cost Summary Power Bi report
- 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
🙋♀️ 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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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