topic Re: Show Values of table based on current logged in user in Developer

Show Values of table based on current logged in user

andtrds — Wed, 14 Sep 2022 10:30:05 GMT

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 user1@demo.com 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

Re: Show Values of table based on current logged in user

Anonymous — Thu, 15 Sep 2022 02:14:37 GMT

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