Forum Discussion
Finding First Name or Last name using DAX like @Username
Hi, I understand that PowerBI records name of all the users who are logged into the app. I am using RLS on username I want to develop a greeting where I greet them with their name such as: ...
Thanks for helping out, however it doesn't seem to be working. It only returns "HelloUser", that's all, and yes userprincipalname returns me email such as [email protected].
Btw I am using Username for Dynamic RLS and not userpricipalname
Hi Anonymous , this is probably long ago solved however adding some value for other searchers.
Stachu solution working well over here, but a small alteration needed on your key.
Recommend using UserPrincipalName() instead for easier consistency
Username() value output is a little volatile as PBI Service will revert it to [username][email], whereas desktop will display as [domain][username].