Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

RLS

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 ...
Data Protection
  • gauthamboppana's avatar
    gauthamboppana
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    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's avatar
gauthamboppana
Solution Specialist
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    gauthamboppana
    Solution Specialist
    4 years ago

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