Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

User ID in Power BI Service

Hi All,

I want to show the user ID (NOT email) of the logged in person in one of my reports. 

I tried using USERNAME() function. The function gives me User ID in Power BI desktop but when I publish the report in Service, this function gives me email ID of the logged in user.

Any way to show User ID of the person instead of email ID in Power BI Service?

 

Your help is greatly appreciated.

Thanks!

Need Help

1 Reply

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    USERNAME is the local user name. In the Power BI Service, this is the same as USERPRINCIPALNAME (email) since that's what's being used "locally" in the cloud.

     

    The service has no information on what a user's local name is outside of the service, so you'll need to include a table in your model that relates the two if you want those local names to be available for use when you publish.