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

Previous
Next

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.