Jon Jowsey on 17 Aug 2016 07:46:21
I want to be able to assign all users (including new ones) to a default role in RLS. Currently I have to assign each user to the role manually, and update the roles manually when users change.
This limits the ability to use RLS with a larger user base.
- Comments (32)
- Merged Idea (1)
RE: Add a default role for row level security
Default role should be assigned through the PBI service. This is especially important once you have implemented dynamic RLS.
RE: Add a default role for row level security
RLS is set at both the data level in the Desktop and then at the Dataset level in the service. I am using the "Username () " DAX function in the desktop to set up a role and join this to a pre-built 2 column table of user ids and Branches each user has access to.
The issue is that in the Service, at the dataset, I need to manual add each user. There should be an option to have ALL users applied the RLS.