Forum Discussion
Post PartisanFilter out using USERPRINCIPALNAME()
You can create an RLS role with the rule
[email] <> USERPRINCIPALNAME()Once you have created a role, anyone you want to view the report must be assigned to a role. This is the intended functionality and there isn't a way to avoid assigning roles if you want to use RLS.
See the documentation and prior discussion here:
https://community.powerbi.com/t5/Desktop/Row-Level-Security-All-Users/m-p/253154
Super Userharshagraj , You can use USERPRINCIPALNAME only in a measure. I doubt you can use that in a column
harshagrajThanks for the reply but how do i solve this problem?
I also tried creating a role like NAME<>LOOKUP(NAME,EMAIL,USERPRINCIPALNAME())
This is also not working properly because i dont have a speicific AD gropu to assign.
- harshagraj
Also if i have to create a measure then how do i aggregate Name column?
If(???(Name)=USERPRINCIPALNAME(),1,0)
Kindly help.
- harshagraj
Hello can someone help on this topic
Greg_Deckler AlexisOlson PhilipTreacy v-zhangti