https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3765639#M33608 <P>Hello<BR />I want to create RLS such as manager can see team members data (2 level below him ) in orgnizational hierarchy<BR /><STRONG>however in my case my there are some values in my "ManagerUID" column which are not present in "EMPUID" Column because of which I cannot use PATH() funtion</STRONG><BR />For 1 level I have used following RLS dax<BR /><STRONG>[UID] = left(username(),6) || [LineManagerUID] = left(username(),6) || [Email] = username() || [LineManagerEmail] = username()</STRONG><BR />Please help me to craete level 2 RLS<BR />Thank you in advance</P> Fri, 15 Mar 2024 08:44:52 GMT prajaktakeni11 2024-03-15T08:44:52Z https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3765639#M33608 <P>Hello<BR />I want to create RLS such as manager can see team members data (2 level below him ) in orgnizational hierarchy<BR /><STRONG>however in my case my there are some values in my "ManagerUID" column which are not present in "EMPUID" Column because of which I cannot use PATH() funtion</STRONG><BR />For 1 level I have used following RLS dax<BR /><STRONG>[UID] = left(username(),6) || [LineManagerUID] = left(username(),6) || [Email] = username() || [LineManagerEmail] = username()</STRONG><BR />Please help me to craete level 2 RLS<BR />Thank you in advance</P> Fri, 15 Mar 2024 08:44:52 GMT https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3765639#M33608 prajaktakeni11 2024-03-15T08:44:52Z https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3767032#M33627 <P>Either fix your hierarchy data or use dynamic RLS.</P> Fri, 15 Mar 2024 15:22:17 GMT https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3767032#M33627 lbendlin 2024-03-15T15:22:17Z https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3767042#M33628 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>&nbsp;<BR />thank you for your reply.....can you help me out with dynamic RLS as I ma new to RLS</P> Fri, 15 Mar 2024 15:27:27 GMT https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3767042#M33628 prajaktakeni11 2024-03-15T15:27:27Z https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3767054#M33629 <P><A href="https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple" target="_blank">Dynamic Row Level Security with Power BI Made Simple - RADACAD</A></P> Fri, 15 Mar 2024 15:34:23 GMT https://community.fabric.microsoft.com/t5/Report-Server/Organizational-hierarchy-RLS-level-2-without-path-function/m-p/3767054#M33629 lbendlin 2024-03-15T15:34:23Z