Forum Discussion

PMXMX's avatar
PMXMX
New Member
3 years ago

Conditional/Multi-Layered Row-Level-Security

Hi Power BI Community,

 

I am having trouble figuring out a multi-layered, dynamic RLS problem. Essentially, I have a table of transactions and employee email adresses. I also have another table of employee emails and their departments.

Depending on which department the user belongs to, I want to provide them with either:

  1. Access to their own transactions only
  2. Access to 1 or more department's transactions

 

How do I go about implementing this?

Dynamic row level security
RLS
Role level security - multiple levels

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    PMXMX , You need to have a department dimension. And Department should be filtered using department email table and on department email table configure rls role

     

    email = userprincipalname()

     

    Power BI- Row Level Security: Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc