Forum Discussion

carlol's avatar
carlol
Resolver I
5 years ago
Solved

RLS Security bypass?

 

I have a Report model based on imported data, it contains all countries ,I need to restrict the dataset to specific countries for User X

 

Row level security appears to be a good option , define the role in the PBIX with the DAX filter, assign the User in PowerBi service

 

Question: Some users are competant with powerBI desktop, Can the User download the PBIX from PowerBi service , have full access to the data contained in the PBIX (They can remove the RLS security)

 

Is it best practice to have a direct query vs imported data to ensure the dataset is protected?

 

 

Data Protection
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    5 years ago

    carlol 

     

    If you are planning to add users to the workspace, then provide viewer role to all the end-users. So, they will not be able to download the pbix file. Also, please note, RLS will not work if the users have edit access (Member/Contributor/Admin).




    Regards,
    Nandu Krishna

    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos 👍

    Proud to be a Super User!

     

2 Replies

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    5 years ago

    carlol 

     

    If you are planning to add users to the workspace, then provide viewer role to all the end-users. So, they will not be able to download the pbix file. Also, please note, RLS will not work if the users have edit access (Member/Contributor/Admin).




    Regards,
    Nandu Krishna

    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos 👍

    Proud to be a Super User!