Dynamic Row Level Security in Power BI with Many to many Best Practice

preview_player
Показать описание
In this video, we will examine another type of security that deals with users and their profiles. Sometimes, a user is part of multiple groups (or profiles), and a profile contains multiple users. This Many-to-Many relationship needs to be incorporated into the way that security works in Power BI. You want all users to see data related to their own profiles. Because this model includes a many-to-many relationship, its implementation differs from the normal dynamic RLS.
Learn more from my blog article here:
  1. RADACAD
  2. Power BI
  3. Power BI from Rookie to Rock Star
  4. Power BI training
  5. Power BI Tutorial
  6. Learning Power BI
Рекомендации по теме
Dynamic Row Level 0:12:47

Dynamic Row Level Security in Power BI

Dynamic Row Level 0:11:16

Dynamic Row Level Security in Power BI with Manager Level Access

Dynamic Row-Level Security 0:08:17

Dynamic Row-Level Security in Power BI

Checking out the 0:04:33

Checking out the new Power BI RLS Editor

Implement Static and 0:15:59

Implement Static and Dynamic Row Level Security (RLS) in Power BI

How to use 0:12:12

How to use DYNAMIC ROW-LEVEL-SECURITY (RLS) in Power BI // Beginners Guide to Power BI in 2021

What is Row-Level 0:05:04

What is Row-Level Security (RLS) in Power BI???

Power BI: Dynamic 0:08:02

Power BI: Dynamic Security Using USERPRINCIPALNAME ()

Printing Power BI 0:16:03

Printing Power BI Analyze in Excel VS Paginated Reports

Power BI 2023: 0:03:59

Power BI 2023: How to Master Dynamic Row-Level-Security

Static and Dynamic 0:16:28

Static and Dynamic Row Level Security in Power BI

Dynamic Row-level Security 0:15:53

Dynamic Row-level Security 🔐 - Based on Dimension Tables

Dynamic Row Level 0:17:17

Dynamic Row Level Security in Power BI with Many to many Best Practice

Dynamic Row Level 0:18:13

Dynamic Row Level Security in Power BI | Top Power BI Interview Question Asked in Interviews

Dynamic Row-Level Security 0:11:38

Dynamic Row-Level Security for Manager Level in Power BI? | RLS In Power BI Ep4 | BI Consulting Pro

Dynamic Row-Level Security 0:10:27

Dynamic Row-Level Security in Power BI for Personalized Data Access

Demo on Dynamic 0:08:19

Demo on Dynamic Row Level Security in POWER BI

Dynamic Row Level 0:06:13

Dynamic Row Level Security in Power BI

Implementing dynamic row-level 0:09:15

Implementing dynamic row-level security in Power BI

Implementing ROW LEVEL 0:10:11

Implementing ROW LEVEL SECURITY - STATIC vs. DYNAMIC RLS | Power BI

What the heck 0:02:37

What the heck is USERPRINCIPALNAME in Power BI? (Row-Level Security)

Dynamic Row Level 0:01:57

Dynamic Row Level Security

Power BI Row-Level 0:09:42

Power BI Row-Level Security And Where To Filter

What is RLS 0:10:34

What is RLS / Row Level Security (RLS) - Restricted Data Access - Power BI Service (22/30)

Комментарии
Автор

Excellent tutorial as always. I had a situation like this. I work for a school district. So, one teacher could have 100 students and each of those students could have multiple teachers. But I needed to create RLS for teachers so that they still only see their own students. You provide a great solution. Thanks.

officesuperhero
Автор

Can you just combine the user and user profile table and use one way filter with many-to-many to profile?

DoThePoint
Автор

your video give me confidence to master in RLS.. Great share... Thanks
can you share or give idea about other way to do the same to avoid bidirection

aliaziz