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.
Create one role with this DAX filter:
[Email] = USERPRINCIPALNAME() ||
PATHCONTAINS('Employee Table (RLS)'[Path], USERPRINCIPALNAME())
Put the special manager's email in your security table with full access flag or just list it first. This gives them OR logic - either hierarchy match OR full access.