microsoft / microsoft/finops-toolkit

One Semantic Model for all reports

Open
#1,928 0 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Tool: FinOps hubs Tool: Power BI
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:

  1. We add one report called FinOps Semantic Model and we publish that with zero dashboards on it --> now we have the Semantic Model online
  2. 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
image

This means that we only have to maintain 1 Semantic model and 1 refresh

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

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.