One Semantic Model for all reports

[flanakin]

Discussed in #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

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