topic RLS Issue in Report Server

RLS Issue

NadiaLR1234 — Tue, 26 Nov 2024 08:04:38 GMT

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 ?

Re: RLS Issue

Jai-Rathinavel — Tue, 26 Nov 2024 11:21:56 GMT

@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

Re: RLS Issue

NadiaLR1234 — Tue, 26 Nov 2024 11:48:07 GMT

thank you will test will accept as solution for now