Forum Discussion

xhurit's avatar
xhurit
Frequent Visitor
5 years ago
Solved

One person in multiple roles RLS

Hi,   I have my dataset configured for RLS and I created 2 groups - ALL and RLS.   Group ALL was created for people that should see all of the data. Group RLS has traditional function as [USERNA...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi xhurit ,

     

    Try modifying Group RLS as [USERNAME] = USERPRINCIPALNAME()&&USERPRINCIPALNAME()<>"the manager"

     

    Best Regards,

    Jay

     

ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. I don't think you can do that. That's Power Bi default behaviour.  If you can't remove him from that group and this is a unique case that won't be repeated, you can add a hardcode rule for RLS with an IF.

IF ( [USERNAME] <> [email protected]; [USERNAME] = USERPRINCIPALNAME() )

You can play with the rule. However the recommendation would be removing the person from RLS group because it should see ALL.

I hope that helps,