Forum Discussion
User in multiple security groups
Usually this is automatic. More permissive rule overrule more restrictive rules. There must be something else going on. Check your RLS rules.
The first security group rule is [User Information List.UserName] = USERPRINCIPALNAME() and the second security group rule is [Region] = "Tampa" || [Employee ID] = x... They use different tables. The first one is using SharePoint and the second one is using a PBI dataflow. Does this give you any clues as to what might be wrong?
"[Employee ID]=x" - please elaborate. At what point is that joined to USERPRINCIPALNAME and how? Are you trying to combine static and dynamic RLS?
x is the Employee ID number. It is not joined to USERPRINCIPLENAME. The first security group is dynamic, while the second security group is static. In this case, I want the static security group to be used, not the dynamic one.
