Locating Object ID in Active Directory Connector

Hi h4n1234 ,

 

You could try the graph API:

• /users/{user_id} targets an individual user in your tenant. You specify the user_id either as the object ID (GUID) or the user principal name (UPN) of the target user. You can use this resource path to get the declared properties of a user, to modify the declared properties of a user, or to delete a user. Note: For an external user, you must specify the user’s object ID (GUID).

 

Request:

GET https://graph.windows.net/myorganization/users?api-version[&$filter]

Body:

{
  "odata.metadata": "https://graph.windows.net/myorganization/$metadata#directoryObjects/Microsoft.DirectoryServices.User",
  "value": [
    {
      "odata.type": "Microsoft.DirectoryServices.User",
      "objectType": "User",
      "objectId": "e61ff361-5baf-41f0-b2fd-380a6a5e406a",
      "deletionTimestamp": null,
......

 

So you can add a blank query in Power BI Desktop, then paste the following code into Advanced Editor of the blank query.

let

Source = Json.Document(Web.Contents("https://graph.windows.net/myorganization/users?api-version=1.6")

in

Source

 

For more information, please refer to the official document:

Azure AD Graph API Operations on Users | Microsoft Docs

Azure AD Graph API Reference | Microsoft Docs

 

Or not in Power Query, but use DAX function——USEROBJECTID() that returns the current user's Object ID from Azure AD or security identifier (SID).

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.