Forum Discussion
RSL Roles/Access for multiple levels in the organization
I have to assign users to get access to specific data in my report. I understand the function of userprincipalname() and that works fine. However, my dataset contains several levels in the organization. VP's level 4, Directors level 5, etc. Can someone guide me in how to have the VPs see their entire organzation, the Directors only theirs etc.?
You can use Dynamic RLS in Power BI, you can create a user table and put the related role level to the table and as it as a dimension table, then create a relationship between the user table and the fact table, you can refer to the following link, it describes how to create the dynamic RLS.
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
You can use Dynamic RLS in Power BI, you can create a user table and put the related role level to the table and as it as a dimension table, then create a relationship between the user table and the fact table, you can refer to the following link, it describes how to create the dynamic RLS.
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.