22-25 April 2026 
Complex access in Power BI with Row-Level Security
2022TL; DR
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.
Session Details
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
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
3 things you'll get out of this session
Speakers
Mathias Halkjaer's other proposed sessions for 2026
Mastering AI in Power BI - 2026
Beware! SQL Injection through ADF/Pipelines - 2026
Fabric Data Agents and beyond - 2026
Ingesting API data with Python Notebooks - 2026
Mastering Direct Lake - 2026
Navigating Data Modeling in Direct Lake - 2026
The Future of Data - 2026
Vibecoding examples for data professionals - 2026
Vibe-coding for the data professional - 2026
When data lies - typical patterns for manipulating data - 2026
Mathias Halkjaer's previous sessions
Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
A deep dive into Direct Lake
The new Direct Lake storage mode in Power BI promises to revolutionize data handling by blending the real-time nature of DirectQuery and the high performance of Import mode. Is this all just hype, or does Direct Lake truly deliver on these claims?
Advanced Power BI refresh with ADF/Synapse
After this session, you will be able to conceptualize and implement different Power BI refresh scheduling patterns in ADF/Synapse. You’ll learn what limitations in Power BI you can overcome with an “external” orchestration tool as well as the different building blocks available. Finally, we will go through an example implementation as well as a step-by-step demo of how you can set this up yourself.
Supercharge Power BI with Azure Synapse Analytics
In this session we will cover how to architect an end-to-end enterpise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.