Forum Discussion
How to get one table to automatically filter another
I am trying to build a report where when users log in, their email filters their view automatically so their only see their or their staff's data. I used PRINCIPALUSERNAME( ) as a measure to auto...
amitchandak
Super User
Super UserAnonymous , We usually use RLS, we join table with table haviing access and email and then use code of first measure
example
[email]=USERPRINCIPALNAME()
Power BI- Row Level Security(RLS): Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc
For Hierarchy
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi