Forum Discussion
Solved
Dynamic RLS Only Works Properly in Desktop
I have a salesman table (name, ID, email) connected to a customer assignment table (customer ID, name, assigned salesperson) connected to a customer table (customer ID, region, etc.). I set up dynami...
Hi, astano05
For RLS to work, a user needs to have read only permission in the workspace.Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset.They can see everything by default. So RLS doesn’t apply to them.
If user can sees additional values outside his territory , please make sure the user can only view the report and have no permission to edit the report.
Best Regards,
Community Support Team _ Eason
Did you assign the role to the person or group holding the person in dataset settings?
Is the sales rep invited to your tenant? If so, the UserPrincipalName() might return a funky format:
So basically, I've determined there are 3 different e-mail formats that get return: 1) regular, 2) live.com# prefix, and 3) abc_workmail.com#EXT#(at)onmail.mail.com