Forum Discussion
Row Level Security issue in Service
Hi All, We created a report with RLS using USERPRINCIPALNAME() and published in service in 2 different workspaces. 1. DEV 2. UAT The report consists of 3 different selection according to ...
Hi Anonymous
To troubleshoot.
- RLS won't work if a user is a member of the Workspace where the report is stored
- Have you assigned the user to the role in the Dataset Security section?
- Not sure what your comany's licensing is, if it is Premium, then the Workspace needs to be Premium for someone to even be able to view a report stored there.
Hope this helps with putting you on the right path
Joe
Hi Joe,
Thank you for the Reply.
- User is not a member of the workspace and he is having the viewer role.
- User addded to security roles in the Dataset and we are holding pro license.
But the in Dev environment for all 3 users RLS is working fine but for 1st user only RLS is not working in UAT.
Let us know any your ideas or some more option to implement if you have to check the issue.
Check the settings in the Dev and duplicate them in UAT. Although the documentation says that a viewer role is ok in a workspace, try removing the User completely from the Workspace and just share the report with them using the Share button and see if it helps. Look into the Dataset permissions, maybe there are some build permissions added by mistake.. Maybe remove all permissions for the user before sharing with the user