microsoft / microsoft/finops-toolkit
One Semantic Model for all reports
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 603
- Forks
- 248
- Avg merge
- 7d 11h
- Merged PRs (30d)
- 11
Description
Discussed in https://github.com/microsoft/finops-toolkit/discussions/1903
Originally posted by francesco1119 December 12, 2025
The FinOps Toolkit currently offers 6 reports with those reservations:
| Power BI report | Data Source |
|---|---|
| Cost summary | ADX |
| Rate optimization | ADX & Storage |
| Invoicing and chargeback | ADX |
| Workload optimization | ADX |
| Policy and governance | ADX |
| Data ingestion | ADX |
So if I deploy all 6 reports I will have also 6 Semantic Models.
wouldn't be better if we can have 1 Semantic Model for all?
SOLUTION:
- We add one report called FinOps Semantic Model and we publish that with zero dashboards on it --> now we have the Semantic Model online
- When we open one of the 6 reports instead of prompting to enter the KQL URL the Power BI report should ask for a Power BI semantic model
This means that we only have to maintain 1 Semantic model and 1 refresh
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
Review Discussion 1903 and the six-report/data-source table first. Define the scope and acceptance criteria for sharing one Power BI semantic model and one refresh across the reports, including how the proposed model report and KQL prompt change should work.
Written by the indexing model from the issue text.
Assessment
- Domain
- analytics, data
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100