How to get current Power BI Sign in ?

[admin_xlsior]

Hi guys,

How to get current Power BI Sign In ? I know there are USERNAME() and USERPRICIPALNAME(), but this is windows login. Inside Power BI, either it is Desktop or Service, we can sign in using different email.

Thanks,

[pranit828 · Accepted solution]

Hi @admin_xlsior 

These functions are the one which will give you the username.

Yes you are right, these functions return differently on Desktop and on Service, But they return the user's name who has signed in.

Create a blank .pbix file with these functions and publish it so see how it is displayed and then you can change as per requirement.

[admin_xlsior]

Hi Pranit828,

Thanks, True. it only correct in Power BI Service.

[negi007]

@admin_xlsior  Hi not able to understand which user information you wish to see. We can use username() to view the login ID used for login and USERPRINCIPALNAME() to view the email id of the user. other than above two which info you wish to see

[admin_xlsior]

Hi negi007,

Yes, exactly. USERNAME() will give me result of my login (windows login), for example when I log in my laptop is DOMAIN1\User1, so it will give that value. And with USERPRINCIPALNAME, it will give his email address, maybe user1@domain1.com

But when sign in to PowerBI, I'm using different email, lets say : user1@test.onmicrosoft.com, I want this instead windows user log in information.

Thanks.

[negi007]

@admin_xlsior USERPRINCIPALNAME() function will show the current email id of the person who has logged into the powerbi. Use this function, it will surely resolve your issue.