Forum Discussion
I am facing issue on Row level security
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
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
Thank 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.
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
