Mar 02 2021 05:12 AM
Hi All
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?
Many thanks
Mar 03 2021 12:35 AM
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.