Object level security: User in multiple security roles

[rebeccaETE]

Hi there, 

I've set up Object Level Security on a table in my data model, published it, and allocated our distribution groups to the two security roles I've created (one with access, one without). 

In our organizations, people can be in several distribution groups, and as so I've run into a problem, when a person is in a distribution group with access and one without access. My users get the error message below. Should I set up "dynamic security configuration" for it to work? And if so, does anyone have some good links to material on how to do that? 

[v-zhangti · Accepted solution]

Hi, @rebeccaETE 

Based on your description, you could need dynamic RLS with a hierarchy.

Please refer to the following link to see if it is helpful to you.

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rebeccaETE]

@v-zhangti Thanks for the reply and the link! I will have a look at the dynamic one. I assume that dynamic OLS is set up in the same way that dynamic RLS is? 

Cheers!