POWER BI username() Desktop

[melvin9900]

Hello,

 I am using Power Bi desktop  and in my report I need to display the Logged user details. So I used the DAX function USERNAME() to display the logged user and USERPRINCIPALNAME() to display the user email address.

During development in my desktop the USERNAME() shows my Domain name which is correct and expected.

But when I upload the report to the ON-Premise report portal both USERNAME() and USERPRINCIPALNAME() displays the email address.  The report portal is logged using the Domain name because the access to the reports are provided using the domain name so I believe the USERNAME() should display the domain name not the email address . Am I missing anything ?

Please let me know.

[Ritaf1983 · Accepted solution]

Hi @melvin9900 
According to Microsoft document, as you publish your report both of these functions return the email address format.

For more information please follow the link:

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly