Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I use RLS and use one of the fields in the database called department.
When I do a simulation everything seems fine. I do the same simulation also in service after I connected the department and the user and everything seems fine.
The problem is when the user logs in he sees all of the Department's and not just his.
Do you have any idea why this is happening?
Tnx Haim
Solved! Go to Solution.
Hi @Haim_is ,
Please check whether that user who can see all department info have the edit permission of the related workspace? The workspace is which the report located in. RLS roles will not be applied to the users who have the edit permission of the workspace... You can find the details in this official documentation.
Best Regards
Rena
Hi @Haim_is ,
Please check whether that user who can see all department info have the edit permission of the related workspace? The workspace is which the report located in. RLS roles will not be applied to the users who have the edit permission of the workspace... You can find the details in this official documentation.
Best Regards
Rena
Hi Rena
You are right some of the users had edit permission.
Acknowledge and appreciate your help.
Best Regards
Haim
@Haim_is - Sounds like the user is either not added to the right RLS role or something along those lines.
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |