Forum Discussion

Iron Contributor

Dec 01, 2022

Report On Combined Data from Intune & Azure AD

Hey there, Is there a way to generate a combined report on data from Intune & Azure AD? For instance, I'd like to get a list of all devices along with Join Type, Owner, MDM, and Activity from AAD...

Intune

DGMalcolm

Iron Contributor

Dec 02, 2022

@Moe_Kinani - That's sort of where I landed but I have little experience with PowerBI. Any references for this approach?

Moe_Kinani

Bronze Contributor

Dec 03, 2022

Hi DGMalcolm,

Many ways you can do it, the easier is to export the data from Azure AD and Intune, then import to PowerBI as CSV files. After importing - Navigate to Model Tab - Manage Relationship - Select Device name from Azure AD and Device Name from Intune - Many to Many relationships. After that done, navigate Report Tab - Select Table on Visualization - Select Columns from both tables.

Sorry about the delay in response and hope this helps!

Moe

DGMalcolm
Iron Contributor
Dec 08, 2022
Moe_KinaniPushing me toward PowerBI was helpful. I got the Intune part quickly, it was the AAD that was harder. Then I found this article:

https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35

Using that I was able to get a connection to AAD then, using your recommendations of the relationships, I was able to get some level of integration. It's still a work in progress but thank you!
- Moe_Kinani
  Bronze Contributor
  Dec 08, 2022
  Glad it’s working for you!
  
  Moe