Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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.
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.
@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!