Semantic Models Comes First: Managing Models for Growth and Self-Service
Proposed session for SQLBits 2026TL; DR
Learn how to design and maintain a clean, scalable Power BI semantic model that supports growth and self-service. We’ll cover what belongs in the core model vs. the report layer, how to extend safely with composite models, when to use UDFs vs. calculation groups, and how tools like Tabular Editor, Semantic Link, and the Power BI MCP server can automate refactoring and model governance.
Session Details
The semantic model should be the stable foundation of your analytics environment. It should not a place for report-specific experiments, formatting measures, or quick fixes. When the core model stays clean and well-structured, teams can extend it through composite models and report-layer logic without adding technical debt.
This session presents a practical semantic model lifecycle: how to design, publish, extend, and refactor models without breaking downstream reports. We’ll compare when to use calculation groups vs. DAX UDFs, where field parameters belong, and how to use Semantic Link and the Power BI MCP server to safely refactor, rename, reorganize, and validate dependencies across environments.
You’ll learn:
What belongs in the shared semantic model vs. the report layer
How to structure measures, folders, relationships, and calc groups for clarity
How composite models enable report-specific logic without polluting the core model
When to choose UDFs vs. calculation groups for reusable logic
How Semantic Link and the MCP server support safe refactoring and lifecycle maintenance
Walk away with a framework for building once, extending safely, and preventing model clutter as your reporting ecosystem grows.
This session presents a practical semantic model lifecycle: how to design, publish, extend, and refactor models without breaking downstream reports. We’ll compare when to use calculation groups vs. DAX UDFs, where field parameters belong, and how to use Semantic Link and the Power BI MCP server to safely refactor, rename, reorganize, and validate dependencies across environments.
You’ll learn:
What belongs in the shared semantic model vs. the report layer
How to structure measures, folders, relationships, and calc groups for clarity
How composite models enable report-specific logic without polluting the core model
When to choose UDFs vs. calculation groups for reusable logic
How Semantic Link and the MCP server support safe refactoring and lifecycle maintenance
Walk away with a framework for building once, extending safely, and preventing model clutter as your reporting ecosystem grows.
3 things you'll get out of this session
Learn how to separate core semantic-model logic from report-specific logic to keep the shared model clean and stable.
Understand a practical lifecycle for designing, extending, and safely refactoring semantic models without breaking reports.
Know when to use calc groups, UDFs, and field parameters so reusable logic stays organized and avoids model clutter.
Speakers
Reid Havens's other proposed sessions for 2026
Building a Data Platform that Delivers ROI, Value, and AI Readiness - 2026
Lights, Camera, Data!: Building Your Brand through YouTube and Speaking - 2026
Navigating Microsoft Fabric: A Practical Guide to Tool Selection - 2026
Power BI Feature Overload: Balancing Flexibility with Maintainability - 2026
Power BI Features I Regret Using (So You Don’t Have To) - 2026
Power BI Settings That Are Secretly Ruining Your Reports - 2026
Scoped for Success: Why Composite Models are a Report's Best Friend - 2026
Speaker Hacks for Nervous Nerds (From a Nerd Who Talks a Lot) - 2026
F is for Fabric - 2026
Reid Havens's previous sessions
Thriving with ADHD in Tech: Unleashing the Data Analyst Superpowers Within
Learn how to leverage ADHD as a distinct advantage in the tech domain, specifically as a data analyst. This session dives deep into the inherent strengths of ADHD individuals, offering actionable strategies to amplify productivity and navigate challenges. Topics include optimizing the ADHD attributes of creativity and hyperfocus for data tasks, crafting an ADHD-conducive workspace, mastering time management, enhancing team communication, and emphasizing mindfulness for career longevity. By the conclusion, attendees will have a comprehensive toolkit to harness their unique ADHD attributes and flourish in the tech landscape.
Supercharge Power BI Tooltips
Discover secrets of tooltip design in Power BI. Learn how to upgrade your tooltips with DAX, add dynamic charts to report page tooltips, and add design elements to information/help tooltips.
Beyond Buttons: More Than Meets The Eye
In this presentation you'll see many unique and creative ways to implement both both bookmarks and buttons to supercharge the filter and navigation experience for your users.