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...
Hi AsNa_92
If you haven't tried with this approch. You can achive this by using Row-Level Security RLS concept. create a DAX measure
[ManagerID] = USERPRINCIPALNAME() || [EmployeeID] = USERPRINCIPALNAME()
You can test the roles in Power BI Desktop by using the "View As" feature to ensure the data is filtered correctly for different users.
If youe need more info, Please go through this Micorsoft Documentation - Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
Thanks.