Forum Discussion
User access level - Data filtering
Hi team, I'm trying to find a way to show the data in a dashboard published based on the user level. So, If the user is manager, he can see data of his team members that are reporting to him onl...
Thank you rohit1991 and suparnababu8
Hi, AsNa_92
I think you can refer to the blogs in the community and use USERPRINCIPALNAME() reasonably for your purposes. Here's a blog that aligns with your needs, with the different job titles and the data they have access to, so you can use them to achieve your goals:
Dynamic Use of USERPRINCIPALNAME() for Dynamic RLS - Microsoft Fabric Community
Dynamic Row Level Security (Dynamic RLS) - Microsoft Fabric Community
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.