RLS

[Anonymous]

Hello, I have created Roles using USERNAMEPRINCIPAL() on my desktop, and each time I run test on PowerBI desktop (View As Role) its working.

However when I publish it to the workspace, It doesnt work ! the user still can see other values.

[gauthamboppana · Accepted solution]

@Anonymous  - Just wanted to confirm whether you have added the users to the RLS role 🙂 Assuming, the user only has 'Viewer' access to the workspace.  

Lastly, are you using USERPRINCIPALNAME ()  or  USERPRINCIPAL() ?

[gauthamboppana]

@Anonymous  - Have you added the users or AD groups to the RLS role in Power BI service?

Click on the dots in the dataset and go to security. Add the Users or AD groups to the role.

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

[Anonymous]

Hello Thanks for your answers but thats extremly basic, ofcourse I have added them to the RLS on PowerBI service.

My issue is that although I added them, they can still see all the data, not only the data assigned to their role.

Thanks again 🙂 

[gauthamboppana · Accepted solution]

@Anonymous  - Just wanted to confirm whether you have added the users to the RLS role 🙂 Assuming, the user only has 'Viewer' access to the workspace.  

Lastly, are you using USERPRINCIPALNAME ()  or  USERPRINCIPAL() ?

[Anonymous · Accepted solution]

USERPRINCIPALNAME()

I managed to solve it, the users that I am granting roles to, are also Members of the Workspace so the permission of the workspace is superiour to the RLS role permission so they can check the data.

I removed them from workspace permission and it worked perfectly, Thanks a lot for your interference and sorry dont take me wrong 🙂 

[gauthamboppana]

@Anonymous  - No worries at all. Happy that you managed to resolve it 🙂