Retrieve the userid when needed

[Anonymous]

Dear all,

I would like to generate automatically the AI Builder consumption report https://youtu.be/8l79x8THx6I

and create a new report with "converted" data with Power BI, since in this report, it gives the IDs (environment ID and user ID). For the Environment id i can create a mapping table. For the userid, it is more complicated to me.... how i can retrieve the ID of a user when it is mentioned in the report?

thank you

[rubayatyasmin · Accepted solution]

Hi, @Anonymous 

use Graph API request. for example

GET https://graph.microsoft.com/v1.0/users

The response is a JSON object that contains user information. It will have many fields, but the ones you are interested in are id and userPrincipalName.

see this document. Use the Microsoft Graph API - Microsoft Graph | Microsoft Learn