USERPRINCIPALNAME DAX Function (Information) Volatile
Returns the user principal name.
Syntax
This expression has no parameters.
Return values
Returns the name of the user as their email address, aka user@domain.com.
Remarks
This function is not supported in calculated tables/columns.
Despite the metadata exposed, this function does not work on Analysis Services 2016.
Examples
-- USERNAME is the local user name (same as USERPRINCIPALNAME using -- Azure AS and Power BI Service) -- USEROBJECTID is the security identifier in Active Directory and -- Azure Active Directory -- USERPRINCIPALNAME is the user principal name, typically the user -- email (it could be different in Active Directory on-premises) EVALUATE { ( "USERNAME", USERNAME () ), ( "USEROBJECTID", USEROBJECTID () ), ( "USEPRINCIPALNAME", USERPRINCIPALNAME () ) }
Related functions
Other related functions are:
Last update: Nov 28, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Gert Christen
Microsoft documentation: https://docs.microsoft.com/en-us/dax/userprincipalname-function-dax