User ID in Power BI Service

[Anonymous]

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!

[AlexisOlson]

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.