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
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