Forum Discussion

RishabSajith's avatar
RishabSajith
Frequent Visitor
5 months ago
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 ...
  • cengizhanarslan's avatar
    5 months ago

    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.