Forum Discussion

Keith Davies's avatar
Keith Davies
Copper Contributor
Mar 02, 2021

Intune Data Warehouse Primary User

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

Intune
  • Alo Press's avatar
    Alo Press
    Iron Contributor
    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.

Resources