Forum Discussion
User in multiple security groups
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.
oh boy. Are the RLS rules impacting the same dimension table?
Oh boy haha. Yes. The second security group was set up as a test to see if I could add more access to the first security group for a specific person.