USEROBJECTID
The user the query runs as, the same text as USERNAME.
Group: Information. Compatible with DAX.
Syntax
USEROBJECTID ( )It takes no parameters.
Returns
Text. The user the query runs as: in OpenBI the same text as USERNAME, an e-mail address on a server.
Remarks
- In OpenBI Studio there is nobody signed in, so it is empty text, except when the Security view's See as names a user: then it is the e-mail address given there, to try out a role's filter.
- On an OpenBI Server it is the e-mail address the person signed in with.
- A role's filter written for Power BI that matches it against a column of object ids finds nobody in OpenBI: match
USERPRINCIPALNAMEagainst e-mail addresses instead.
Compared with DAX
Power BI gives the user's object id in Microsoft Entra ID, a GUID. OpenBI identifies people by their e-mail address and gives that, the same as USERNAME.
Examples
Who runs this query
EVALUATE
ROW ( "Id", USEROBJECTID () )| Id |
|---|
| (varies) |