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.
» 3 related functions
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 articles
Learn more about USEROBJECTID in the following articles:
-
Introducing user-aware calculated columns in Power BI
This article describes the new Expression Context property of calculated columns in Power BI, explaining how user-aware calculated columns work, why they are not materialized, and how to use them as virtual calculated columns for localization and custom security scenarios. » Read more
Related functions
Other related functions are:
Last update: May 19, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/userobjectid-function-dax