USEROBJECTID DAX Function (Information) Volatile
Returns the current user’s Object ID from Azure AD for Azure Analysis Server and the current user’s SID for on-premise Analysis Server.
Syntax
This expression has no parameters.
Return values
It is the security identifier (SID) in Windows, and another identifier in the Power BI or Azure Analysis Services service.
This function is not supported in calculated tables/columns.
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 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/userobjectid-function-dax