Forum Discussion

chestercas's avatar
chestercas
Icon for Helper I rankHelper I
3 years ago

RLS : restrict one username

Hi,

 

I need help... 😞 
I need to restrict the data to one user. All the other user must have access to all data.
So I create a new role.
[2nd manager] = USERPRINCIPALNAME ().
This user have access to one team, and don't have the other line. But all the other person don't have any access.

Some user don't be in the table "username" (because they are worker from other services). So I need to tell to power bi : "If the user XXX is connected, show the line where he's mentionned. But ALL THE OTHER PEOPLE have access to the complete table".

Is it possible ?

Thanks for help !

4 Replies