How to visualize Microsoft Graph API data in PowerBi?

Mwinia 1 Reputation point
2022-08-29T14:56:25.06+00:00

I’m currently working on a Power Bi dashboard where I can check the compliancy status of alle the laptops in the organization. Therefore I’m using the Intune Data Warehouse data for visualizing the compliancy status of all laptops.

I want to expand the dashboard with visualizations on the Azure AD device data and I’m currently looking for a way to import Azure AD Devices data into PowerBi. Does anyone know how I can achieve this?

I have read on various forums that Microsoft Graph API is the best solution for this, but what is the best way get this data into PowerBi? What is the best way to setup a connection with this API?

In addition, I would like to combine two Graph datasets/queries. I would like to see the device information, in combination with the registered Owner, in one query. With the two queries below I can find the correct data, but is there a possibility to merge these queries into one so that I can immediately see the registeredOwner of each Device?

GET https://graph.microsoft.com/v1.0/devices
GET https://graph.microsoft.com/v1.0/devices/{id}/registeredOwners

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,180 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2022-08-29T15:02:07.147+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments