This solution presents an automated governance framework for Microsoft Fabric semantic models that helps organizations detect duplication, reduce semantic model sprawl, and improve reuse across workspaces and capacities. The notebook scans semantic models using either service principal or current-user access, analyzes datasource and metadata patterns, identifies duplicate or overlapping models, and turns the findings into actionable governance outputs for administrators and data owners.
Capabilities:
Semantic Model Discovery: Scans semantic models across Microsoft Fabric workspaces and capacities, with support for admin APIs, workspace-level access, and optional workspace targeting.
Duplicate Source Detection: Identifies semantic models that connect to the same normalized datasource and highlights consolidation opportunities to promote shared semantic layers and reduce redundant logic.
Probable Overlap Detection: Detects likely duplicate or overlapping semantic models by comparing entities, columns, and metadata, even when datasource metadata is incomplete.
Actionable Governance Outputs: Produces prioritized action plans, executive summaries, responsibility views, diagnostics, and compact visual tables that help teams focus on the most important governance decisions.
Ownership and Collaboration Support: Maps impacted semantic models to dataset owners and workspace admins, and generates email drafts to accelerate review, coordination, and remediation.
Noise Reduction and Flexibility: Supports exclusions for intentional duplicates, sandbox models, and workspace-specific exceptions, while suppressing likely deployment clones to reduce false positives.
Microsoft Fabric-Native Experience: Designed as a Fabric notebook solution with visual-first output, configurable execution modes, and optional SemPy enrichment for deeper semantic model metadata.
Business value:
This solution helps data teams improve governance, reduce duplication, strengthen semantic model reuse, and create a clearer path toward centralized, maintainable, and trusted analytics assets in Microsoft Fabric.
All code and documentation can be found in the GitHub repository.
https%3A%2F%2Fgithub.com%2Fchristiantodte%2FSemanticRadar
