Intune Data Warehouse Primary User

%3CLINGO-SUB%20id%3D%22lingo-sub-2177736%22%20slang%3D%22en-US%22%3EIntune%20Data%20Warehouse%20Primary%20User%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2177736%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20pull%20in%20the%20Device%20Primary%20User%20from%20the%20Intune%20Data%20Warehouse%20into%20Power%20BI%3C%2FP%3E%3CP%3EIt%20appears%20that%20the%20Device%20Primary%20User%20is%20not%20visible%2C%20or%20even%20exists%2C%20within%20the%20Data%20Warehouse%20but%20the%20UPN%20is%20available.%3C%2FP%3E%3CP%3EAm%20I%20missing%20something%3F%20Is%20the%20Device%20Primary%20User%20available%20within%20the%20Intune%20Data%20Warehouse%3F%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2177736%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIntune%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2181066%22%20slang%3D%22en-US%22%3ERe%3A%20Intune%20Data%20Warehouse%20Primary%20User%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2181066%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F179852%22%20target%3D%22_blank%22%3E%40Keith%20Davies%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20the%20Microsoft%20docs%20page%20it%20does%20look%20like%20Intune%20Data%20Warehouse%20has%20a%20UPN%20value%20with%20the%20property%20of%20%3CSTRONG%3EuserPrincipalName%3C%2FSTRONG%3E%26nbsp%3Bbut%20for%20the%20devices%20themselves%20it%20looks%20like%20the%20%3CSTRONG%3EuserId%3C%2FSTRONG%3E%20property%20is%20used%20to%20link%20devices%20to%20specific%20users.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERead%20more%20from%20Microsoft%20docs%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmem%2Fintune%2Fdeveloper%2Fintune-data-warehouse-collections%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EIntune%20Date%20Warehouse%20Collections%3C%2FA%3E%26nbsp%3Bor%20in%20more%20detail%20the%20following%20collections%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmem%2Fintune%2Fdeveloper%2Fintune-data-warehouse-collections%23users%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eusers%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmem%2Fintune%2Fdeveloper%2Fintune-data-warehouse-collections%23devices%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Edevices.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2340632%22%20slang%3D%22en-US%22%3ERe%3A%20Intune%20Data%20Warehouse%20Primary%20User%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340632%22%20slang%3D%22en-US%22%3EOkay.%20Thanks%20for%20your%20help%20Alo%3C%2FLINGO-BODY%3E
New Contributor

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

2 Replies

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.

Okay. Thanks for your help Alo