I`ve created a report using the PATH function in order to enable RLS viewing options.
What I don`t like is that it`s listing the current user in the hierarchy and I need the logged in user to only be able to see data about employees reporting to them.
Adding a sample of my data below and the desired result.
Go to Solution.
@pbirookie , Try a new column
New column = substitute([path],"|"&[ID],"")
View solution in original post
Thank you for this simple and great suggestion, @amitchandak !
It works great for this column.
Still, when I`m using the userprincipalname () function to view as one of my users, I can still see their own names listed.
Can you please advise how I can solve this?
Click here to read more about the October 2021 Release!
Explore the latest tools,training sessions,technical expertise, networking and more.
Mark your calendars and join us for our next Power BI Dev Camp!