Forum Discussion
How to visualize Microsoft Graph API data in PowerBi?
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 to 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
1 Reply
Hi Anonymous
Connecting to Microsoft Graph REST APIs from Power Query isn't recommended or supported. Instead, we recommend users explore alternative solutions for retrieving analytics data based on Graph, such as Microsoft Graph data connect.
You might find you can make certain REST calls to Microsoft Graph API endpoints work through the
Web.ContentsorOData.Feedfunctions, but these approaches aren't reliable as long-term solutions. The following article outlines the issues associated with Microsoft Graph connectivity from Power Query and explains why it isn't recommended.Lack of Support for Microsoft Graph in Power Query - Power Query | Microsoft Docs
If you want to use Power Query to get data from Graph APIs, these blogs / articles may be helpful:
Use Graph API data in Power BI using Logic Apps - JanBakker.tech
Easily connecting between Power Query / Power BI and Microsoft Graph | by Chris Hill | Medium
Connecting Power BI to Microsoft Graph - Microsoft Tech Community
Once you get data from two Graph queries, you can extract the data you want and convert it into two tables. If they have a common column (e.g. device id), you can use Merge queries to bring one column from a table into the other table. Before merging, choose the common column(s) as matching column(s).
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
