Forum Discussion
PMXMX
3 years agoNew Member
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...
amitchandak
3 years agoSuper User
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