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

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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!