Application Insights - user_AuthenticatedId to Azure UPN

Question

I have hooked up a Power App to Azure Application Insights to track useage.

When the events are logged, the user ID is recorded with the Azure Active Directory ID (a Guid).

Whilst I can interrogate AAD for the user ID manually to get the UPN, is there any way in the App Insights Data Explorer to map the user ID to the UPN.

pageViews 
| where timestamp  > datetime(2021-02-04 14:30:00)
| project user_AuthenticatedId, '[UPN]'

Answer 1

Well, it was a bit of a round-a-bout way of doing this, but I created a Power Automate flow using various HTTP REST calls.

Firstly, I pulled the list of User IDs from App Insights using the REST Api with a query and then cycled over the response making HTTP requests to the MS Graph API requesting the user information.

It needed an Azure App Registration with appropriate security access to call into Graph but it was a simple task end the end.