cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carlol
Helper II
Helper II

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?

 

 

1 ACCEPTED SOLUTION
nandukrishnavs
Community Champion
Community Champion

@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!

 

View solution in original post

2 REPLIES 2
nandukrishnavs
Community Champion
Community Champion

@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!

 

View solution in original post

Thanks!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!