Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
NadiaLR1234
Helper I
Helper I

RLS Issue

Hi

 

I applied multiple row level security per Company Brand and then added the relevant email addresses (which has the brand in the username) of each person that can see that brand to RLS on app.powerbi.com PBI Services - Microsoft Fabric however some persons can see all brands even though they are only added to one, please help me in what wrong.

 

I added them all to workspace manage access and to each role in security can this be the issues ? However I have also came accross if I don't add them to workspace access then they cannot download underlying data (which is selected) not sure what else to check - however not sure if I can add it to manage roles as some emails needs to be all brands too ?

1 ACCEPTED SOLUTION
Jai-Rathinavel
Solution Supplier
Solution Supplier

@NadiaLR1234 If you have added the peoples to workspace as member or contributor or admin, RLS will not affect them, they will still be able to see all the data. If you want to make your RLS work you have to change their access to viewer and they will be able also able to export the RLS filtered data via export to csv option from the visual.

 

Did I answer your question ? Please mark my post as a solution.

 

Thanks,

Jai

View solution in original post

2 REPLIES 2
NadiaLR1234
Helper I
Helper I

thank you will test will accept as solution for now 

Jai-Rathinavel
Solution Supplier
Solution Supplier

@NadiaLR1234 If you have added the peoples to workspace as member or contributor or admin, RLS will not affect them, they will still be able to see all the data. If you want to make your RLS work you have to change their access to viewer and they will be able also able to export the RLS filtered data via export to csv option from the visual.

 

Did I answer your question ? Please mark my post as a solution.

 

Thanks,

Jai

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.