Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

How to get current Power BI Sign in ?

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,

  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      admin_xlsior
      Post Prodigy

      Hi Pranit828,

       

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

  • negi007's avatar
    negi007
    Community Champion

    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's avatar
      admin_xlsior
      Post Prodigy

      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 [email protected]

       

      But when sign in to PowerBI, I'm using different email, lets say : [email protected], I want this instead windows user log in information.

       

      Thanks.

      • negi007's avatar
        negi007
        Community Champion

        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.