SESSION Details
Complex access in Power BI with Row-Level Security
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
Starts: 09:30 12th Mar 2022
Ends: 10:20 12th Mar 2022
Q&As
Short Description
- 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.
Other technologies
- Power Automate, Forms, Azure Active Directory
Slidedeck Link
Complex access in Power BI with row-level security.pdf
Speakers
Mathias Halkjaer
Tags
None of the AboveIntelligence and AnalyticsSecure and GovernManagingModellingSecurityPower BIAdvancedHow
The SQL Bits Story
SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.
As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years
We’ve grown and expanded a lot since 2007.

2500 Participants
SQLBits is the best place to meet fellow data professionals.

82 Countries
We welcome data professionals from all over the globe.

1140 recorded sessions
All the live sessions are recorded and offered for free, year round.
Experience the SQLBits Conference
Want to be part of the SQLBits community?
Attend the London conference in-person or virtually on
March 8-12, 2022 at ExCel London, UK.
