22-25 April 2026

Upgrading Power BI Architecture

Proposed session for SQLBits 2026

TL; 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.

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

havensconsulting.net/blog-and-media