Microsoft Security | Microsoft Graph
An API that connects multiple Microsoft services, enabling data access and automation across platforms
UserID using the reporting API and Graph API in the same tenant do not match
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 50%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Patrik Grönholm
0
Reputation points
Hi,
We are working with a client who wants to modify the existing Power BI M365 Usage Analytics Report by adding data from Entra using the Graph APIs. Since the logical connection would be to build a relationship using the UserID string between the two different APIs , we noticed that the UserID strings didn't match at all. We also tried using UPN, but that is not a very liable solution since there might be different values for the same user.
The documentation says the following:
UserId Unique user ID that represents a user and enables joining with other data tables within the data set.
UPN User principal name, uniquely identifies the user to be able to join with other external data sources.
What would be the right way to combine user data between the two different APIs?
Microsoft Security | Microsoft Graph
Sign in to answer