Forum Discussion
Solved
RLS Query - Power BI
Hello Microsoft Community, I’m fairly new to Row-Level Security (RLS) and have successfully implemented RLS based on a hierarchy using a summary table that contains the hierarchy structure. So when ...
You can extend your existing rule with an OR condition for the users who should have full access.
PATHCONTAINS ( 'Employee Table (RLS)'[Path], USERPRINCIPALNAME() ) || USERPRINCIPALNAME() = "[email protected]"Or simply create a new role and add those people who will have full access withount bounding to the role with RLS.
You can extend your existing rule with an OR condition for the users who should have full access.
PATHCONTAINS ( 'Employee Table (RLS)'[Path], USERPRINCIPALNAME() )
|| USERPRINCIPALNAME() = "[email protected]"
Or simply create a new role and add those people who will have full access withount bounding to the role with RLS.
Hello cengizhanarslan ,
Adding this email ID to the DAX formula in the formula was indeed the easiest to do.
Thank you all!