Mar 02 2021
I am trying to pull in the Device Primary User from the Intune Data Warehouse into Power BI
It appears that the Device Primary User is not visible, or even exists, within the Data Warehouse but the UPN is available.
Am I missing something? Is the Device Primary User available within the Intune Data Warehouse?
Mar 03 2021
Hi @Keith Davies
Based on the Microsoft docs page it does look like Intune Data Warehouse has a UPN value with the property of userPrincipalName but for the devices themselves it looks like the userId property is used to link devices to specific users.
Read more from Microsoft docs Intune Date Warehouse Collections or in more detail the following collections - users and devices.