RLS with Multiple Roles

Hi Nichita_J ,

Thank you for reaching out to Microsoft Fabric Community forum.

lbendlin Thank you for your quick response.

Instead of using two roles, create one combined RLS role with conditional logic like:

OR(
RELATED(UsersAdmin[UserPrincipalName]) = USERPRINCIPALNAME(),
PATHCONTAINS(ManagerData[SupervisorPath], USERPRINCIPALNAME())
)

You'll write this logic in a calculated column or as a DAX filter on a bridge/junction table if necessary. This will allow you to assign one unified role and let the logic handle who sees what.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
B Manikanteswara Reddy