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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ButtersStotch
Regular Visitor

Row Level Security For Existing Report

I need to give someone an access to my report - limited access: the new user only needs to see a certain set of data. RLS to the rescue. Thing is, the existing report they need to have limited access to, has not been set up to have RLS. So I set up the role, give them access, add them to the role, and they are good to go. Unfortunately, I start receiving feedback from previous existing users that they can't access the report because of the error below, which is about RLS. I was able to fix it by setting up another role without restrictions, then adding them to that role.

My question is, is this really how RLS behaves? If someone is an existing viewer to an existing report, and this report is updated to have RLS, that viewer will need to be on a role to access the report again? I was under the impression that previous users would be unaffected?

 

ButtersStotch_0-1627710079725.png

 

 

1 ACCEPTED SOLUTION

Unfortunately this is how it is... As you apply RLS then every user has to be assigned to a role.

View solution in original post

4 REPLIES 4
Mohammad_Refaei
Solution Specialist
Solution Specialist

Create a new role name it Global for example without any security filters, and assign all your previous users to it.

Thanks, @Mohammad_Refaei . That's exactly what I did. So is this how it behaves? Everytime we update a previously non-RLS report to an RLS report, we need to put all existing users to a separate role without filters? Seems super inconvenient. Shouldn't they be unaffected because they are able to access the report without restrictions in the first place?

If you work with AD groups, the additional effort isn't that much. You should try to avoid adding individual users but use groups instead

Unfortunately this is how it is... As you apply RLS then every user has to be assigned to a role.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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