Forum Discussion
Anonymous
5 years agoNot applicable
Row Level Security based on EmailID
Hello, I am working on a dashboard where we have 4 potential users: Business Head, Sales Rep, District Manager and Region Manager. Each Account has 4 of these emails associated and I have an Acc...
Payeras_BI
Solution Sage
5 years agoHi Anonymous,
I'll better share my testing with you.
Table AA:
Table XX:
Because I am working in PBI desktop I'll use my local machine's username instead of my email address just for testing purposes.
No relationship needed:
Creating the Role:
Table AA is filtered accordingly:
I hope this helps.