Forum Discussion
Helper II am facing issue on Row level security
Dear Power BI Champians,
I need a help on RLS creation on power bi. Actually i have three table expenses, services and timesheet and each table connected each other. i have a create a RLS on 3 level. like divison wise. Example:- each Division have different manager each manager can see his all own division employee data and employee can see only own data based on login. I have shared the data please help me.
its very urgent i will be always thankful for you.
Hey prinuce ,
this article by Reza Rad explains how to implement Row Level Security that considers an organizational structure: Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship - Part 1 - RADACAD
If this is not enough create a pbix that contains sample data (a screenshot is not enough), but still reflects your data model (three tables), upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx file as well.
Regards,
Tom
Hey prinuce ,
create a 2nd role, just add a simple DAX statement that always returns TRUE like 1 = 1, and assign the one person that needs to see everything to this role.
Hopefully, this provides what you are looking for
Regards,
Tom
5 Replies
- TomMartens
Super User
Hey prinuce ,
this article by Reza Rad explains how to implement Row Level Security that considers an organizational structure: Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship - Part 1 - RADACAD
If this is not enough create a pbix that contains sample data (a screenshot is not enough), but still reflects your data model (three tables), upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx file as well.
Regards,
Tom
prinuceThank you TomMartens i have created organization level hierarchy.
I have assign RLS for all user.
Dax is:-
PATHCONTAINS(RLS[Path],
MAXX(
filter(RLS,
[Employee Email] = userprincipalname()),
RLS[Full NameId]))@. But my question now i want to assign one person on RLS to see all details in report not only related to him. Please help me this.
- TomMartens
Hey prinuce ,
create a 2nd role, just add a simple DAX statement that always returns TRUE like 1 = 1, and assign the one person that needs to see everything to this role.
Hopefully, this provides what you are looking for
Regards,
Tom
- prinuce
- prinuce
please help me.
I have three table expenses, timesheet and services I am creating RLS in power bi need help each division have different manager each manager can see his all own division employees data of timesheet, expenses and services and employee can see only own data of this three table. i have shared the data above please check..