https://community.fabric.microsoft.com/t5/Report-Server/2-level-path-using-PATH-Function/m-p/3766086#M33617 <P>Hello I am using multilevel orgnizational hierarchy in my table bu I want to use RLS only upto 2 level<BR />for example manager can view data of people (2 level below him)<BR />I have used PATH() function but in that I am getting entire path i want upto <STRONG>2 level</STRONG><BR />Thank you in advance<BR /><img /><BR /><BR /><BR /></P> Fri, 15 Mar 2024 10:45:33 GMT prajaktakeni11 2024-03-15T10:45:33Z https://community.fabric.microsoft.com/t5/Report-Server/2-level-path-using-PATH-Function/m-p/3766086#M33617 <P>Hello I am using multilevel orgnizational hierarchy in my table bu I want to use RLS only upto 2 level<BR />for example manager can view data of people (2 level below him)<BR />I have used PATH() function but in that I am getting entire path i want upto <STRONG>2 level</STRONG><BR />Thank you in advance<BR /><img /><BR /><BR /><BR /></P> Fri, 15 Mar 2024 10:45:33 GMT https://community.fabric.microsoft.com/t5/Report-Server/2-level-path-using-PATH-Function/m-p/3766086#M33617 prajaktakeni11 2024-03-15T10:45:33Z https://community.fabric.microsoft.com/t5/Report-Server/2-level-path-using-PATH-Function/m-p/3767217#M33630 <P>PATHITEMREVERSE()</P> Fri, 15 Mar 2024 16:48:54 GMT https://community.fabric.microsoft.com/t5/Report-Server/2-level-path-using-PATH-Function/m-p/3767217#M33630 lbendlin 2024-03-15T16:48:54Z