Building a Unified Semantic Model - The 20-Minute Pattern
Proposed session for SQLBits 2026TL; DR
A fast, practical demonstration of how to build a unified semantic model that combines KPIs from multiple domain models - without building a mega model.
Session Details
Organizations often need a combined KPI view across several domain semantic models. Instead of building an unwieldy “mega model” or maintaining dashboards that duplicate logic, you can use a clean unified semantic model pattern.
This lightning session shows the core 20-minute approach for creating a unified model: which elements to import, how to reuse existing logic, how to keep domain models independent, and how to design for easy maintenance.
This lightning session shows the core 20-minute approach for creating a unified model: which elements to import, how to reuse existing logic, how to keep domain models independent, and how to design for easy maintenance.
3 things you'll get out of this session
Understand the core structure of a unified semantic model
Learn what to import—and what to avoid
Minimize duplication while keeping models domain-aligned
Apply a repeatable, lightweight pattern you can implement immediately
Avoid the pitfalls of mega models and dashboard sprawl
Speakers
Just Blindbæk's other proposed sessions for 2026
Choosing the Right Storage Mode: Import, Direct Lake, DirectQuery & Hybrid - 2026
Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026
Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026
Demystifying the Data Lakehouse in Microsoft Fabric - 2026
Mastering Spark Notebooks and Capacity Optimization in Microsoft Fabric - 2026
Unified Semantic Models & KPI Reporting: Architecture That Scales - 2026
Just Blindbæk's previous sessions
Mastering Fabric: Workspace Governance and Organization
Learn how to optimize and master workspace organization in Fabric. Explore best practices for effective governance, enhancing user experience, security, and permissions management. Gain practical insights and checklists for streamlined workspace management.
The Hitchhiker's Guide to navigating Power BI
Learn to navigate Power BI seamlessly in this concise session. Explore key areas: Internal Report navigation, App transitions, and Web Portal optimization. Elevate user experience with insights on service navigation, integration, and essential tools like Drill Through, Buttons, and Bookmarks.
Architectural blueprints for the Modern Data Warehouse
This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.
Power BI: From Self-Service to Enterprise
How do you master to grow a Power BI solution from self-service to something that is scalable, managed and governed? A solution that can be trusted and used in the whole enterprise! Make a successful ownership transfer!
Excel Services 2013-the BI frontend of the future
The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective.
(1) Overview of the publish options
(2) How to control the layout
(3) Tips & Trick from real world examples