Forum Discussion
Helper VRLS using USERPRINCIPAL Name - for 50+ users - need to add them all individually?
In Dynamic RLS you usually have a single role. That role has ideally only distribution lists as members , usually PDLs maintained by an external tool.
Helper VMaybe I misunderstood how RLS works but I thought that everyone who needs to be secured - in addition to being in the database - and filtered via RLS - they also need to be added to the role in PBI service for the given semantic model's security here:
ie. this is not the last step:
...still need everyone to be added individually to PBI service role. Not great as we have 50 or so users so far and there will be many more in the future. And cannot assign a group to a role - and have it work.
Super UserIn Dynamic RLS you usually have a single role. That role has ideally only distribution lists as members , usually PDLs maintained by an external tool.