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 ...
Need Help
Show and Tell
Tips and Tricks
  • cengizhanarslan's avatar
    cengizhanarslan
    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.

danextian's avatar
danextian
Super User
5 months ago

Try this:

IF (
    USERPRINCIPALNAME() = "[email protected]",
    TRUE(),
    PATHCONTAINS ( 'Employee Table (RLS)'[Path], USERPRINCIPALNAME() )
)


or

IF (
    --if there is a table of managers to exempt
    USERPRINCIPALNAME() IN  VALUES ( ExemptedManagersTable[manager email] ) 
    TRUE(),
    PATHCONTAINS ( 'Employee Table (RLS)'[Path], USERPRINCIPALNAME() )
)
v-menakakota's avatar
v-menakakota
Community Support
5 months ago

Hi RishabSajith ,

I would also take a moment to thank danextian , cengizhanarslan  and wardy912   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the issue has been resolved. If you continue to experience any problems, please reach out here and we will assist you.

Best Regards, 
Community Support Team