RLS

[Anonymous]

hello,

i'm trying to create a dynamic security rule that allows a user to see several departments but i'm not able to create the rule. I already created the hierarchy, just the rule is missing.
this link has the example pbix.
thankful already

simple,pbix

[amitchandak]

@Anonymous , refer if these two can help

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

[Anonymous]

Hello @amitchandak 

thanks for the help but this technique doesn't work because my hierarchy is made with text.

do you have any more ideas?