Forum Discussion
Show Values of table based on current logged in user
Hello
i have a table the has sample values like :
Value 1
Value 2
Value 3
i d like to create the following
when a user logged in with email [email protected] to see only Value1 and selected automatically
i use RLS to see only the specific value but i cant make it to be selected automatically,user has to clik the Value 1
any help?
thank you
Hi andtrds,
You can create RLS based on username or userprincipalname function and filter on the table field that stored user account values. This filter will extract the current username as a condition to filter records.
Solved: RLS with UserName() - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
1 Reply
Hi andtrds,
You can create RLS based on username or userprincipalname function and filter on the table field that stored user account values. This filter will extract the current username as a condition to filter records.
Solved: RLS with UserName() - Microsoft Power BI Community
Regards,
Xiaoxin Sheng