22-25 April 2026

How Notebooks Help You Manage Power BI Access

Proposed session for SQLBits 2026

TL; DR

Discover how notebooks can automate Power BI access management at scale. Learn how to replace manual, error-prone processes with auditable scripts that improve security, efficiency, and governance across all workspaces.

Session Details

Description:
This session will explore how notebooks can transform Power BI administration, particularly in large organizations. Manual management of access and resources in Power BI can be time-consuming and error-prone. Implementing notebooks to automate these processes can save time, reduce human errors, and enhance security.

What the Audience Will Learn:
The importance of Power BI administration and its impact on data security and management.
Different methods for managing access in Power BI.
Challenges associated with manual access management.
How notebooks automate management, improve efficiency, and enhance traceability.

Demonstrations:
The session will include demonstrations of scripts that automatically remove manually granted access at the workspace level. These scripts will show how to revoke access across all workspaces using notebooks and the libraries sempy.fabric y sempy_labs.

Benefits:
Attendees will learn how to leverage notebooks to improve the administration of Power BI, making access management more effective and scalable. This session is ideal for Power BI administrators and IT professionals seeking to enhance their data environments through automation.

3 things you'll get out of this session

Understand common access-management challenges in large Power BI environments. Learn how notebooks automate and standardize workspace-level permissions. See practical scripts using sempy.fabric and sempy_labs to revoke access at scale.