Dynamic Row Level Security in Power BI with Many to many Best Practice
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:
https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi