Upgrading Power BI Architecture
Proposed session for SQLBits 2026TL; DR
This course teaches users to create, manage, and secure enterprise-grade Power BI models, covering semantic modelling, deployment pipelines, sharing strategies, and access control, enabling scalable, collaborative, and secure analytics.
Session Details
This course is designed for users who want to learn to enhance Power BI models for enterprise deployment, creating sharing strategies, and ensuring security. In this course, you will learn valuable tools and skills to create, configure, and manage enterprise-grade Power BI models and take your organization's data analytics to the next level.
First, the session will review how to architect semantic models for enterprise use. It will look at configuring tables, columns, hierarchies, and measures, using tools such as Tabular Editor.
Next, it covers version control, DevOps, and build and deployment pipelines. We’ll look at a range of tools such as Tabular Editor, Visual Studio, Azure DevOps, or GitHub. We’ll cover all terminology at an introductory level, so you won’t get left behind. You will learn publication options, how to configure datasets, incremental refresh, use very large datasets, configure workspaces, and control workspace access.
Then we’ll cover different sharing strategies for distributing content and how to collaborate with workspaces. You will learn how to configure role-based access control (RBAC), implement RLS and OLS, and apply security labels. We’ll learn some common data leak pitfalls and how to avoid them.
Participants should have a basic understanding of Power BI and data modeling concepts, including tables, relationships, and measures. Prior experience with Tabular Editor and DevOps is not required, but it may be helpful.
First, the session will review how to architect semantic models for enterprise use. It will look at configuring tables, columns, hierarchies, and measures, using tools such as Tabular Editor.
Next, it covers version control, DevOps, and build and deployment pipelines. We’ll look at a range of tools such as Tabular Editor, Visual Studio, Azure DevOps, or GitHub. We’ll cover all terminology at an introductory level, so you won’t get left behind. You will learn publication options, how to configure datasets, incremental refresh, use very large datasets, configure workspaces, and control workspace access.
Then we’ll cover different sharing strategies for distributing content and how to collaborate with workspaces. You will learn how to configure role-based access control (RBAC), implement RLS and OLS, and apply security labels. We’ll learn some common data leak pitfalls and how to avoid them.
Participants should have a basic understanding of Power BI and data modeling concepts, including tables, relationships, and measures. Prior experience with Tabular Editor and DevOps is not required, but it may be helpful.
3 things you'll get out of this session
Learn to architect and optimise enterprise-grade Power BI models for performance, scalability, and collaboration.
Understand deployment pipelines, version control, and best practices for DevOps integration in Power BI.
Gain skills to implement secure sharing, role-based access, and data protection strategies across workspaces.
Speakers
Reid Havens's other proposed sessions for 2026
Becoming a Master Builder: Creating the Ultimate BI Developer Toolbox - 2026
Building a Data Platform that Delivers ROI, Value, and AI Readiness - 2026
Design a Well-Architected Fabric Solution: A Medallion First Approach - 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
Semantic Models Comes First: Managing Models for Growth and Self-Service - 2026
Speaker Hacks for Nervous Nerds (From a Nerd Who Talks a Lot) - 2026
F is for Fabric - 2026
Fabric for Muppets - 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.
Steve Campbell
Steve Campbell's other proposed sessions for 2026
Becoming a Master Builder: Creating the Ultimate BI Developer Toolbox - 2026
Building a Data Platform that Delivers ROI, Value, and AI Readiness - 2026
Design a Well-Architected Fabric Solution: A Medallion First Approach - 2026
Navigating Microsoft Fabric: A Practical Guide to Tool Selection - 2026
Scoped for Success: Why Composite Models are a Report's Best Friend - 2026
Semantic Models Comes First: Managing Models for Growth and Self-Service - 2026