Conditional/Multi-Layered Row-Level-Security

PMXMX — Tue, 04 Apr 2023 17:45:31 GMT

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:

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

How do I go about implementing this?

Re: Conditional/Multi-Layered Row-Level-Security

amitchandak — Wed, 05 Apr 2023 02:09:13 GMT

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

topic Re: Conditional/Multi-Layered Row-Level-Security in DAX Commands and Tips

Conditional/Multi-Layered Row-Level-Security

Re: Conditional/Multi-Layered Row-Level-Security