22-25 April 2026
Video unavailable
SQLBits 2022

Complex access in Power BI with Row-Level Security

In this session, you will tag along the journey of working towards a solution to this problem. We will touch upon topics like automated workflows with Power Automate, Active Directory Security Groups, Decoupled Datasets and Security Tables, all combined with Row-Level Security to bring them all together.
How do you manage data access with hundreds of users spread across departments, countries, or even companies while using the same Power BI dataset across those entities?

In this session, you will tag along the journey of working towards a solution to this problem. We will touch upon topics like automated workflows with Power Automate, Active Directory Security Groups, Decoupled Datasets and Security Tables, all combined with Row-Level Security to bring them all together.

You will be introduced to various advanced methods for handling data access in Power BI so that you will also be able to design highly flexible and dynamic security setups. The whole ordeal will be sprinkled with my experiences, failures, and successes in implementing such a setup in a multinational company.

Topics:
- Row-Level Security
- Workflow Automation (Power Automate)
- Decoupled Datasets
- Active Directory Security Groups
- Security Tables

Feedback link: https://sqlb.it/?7022