Forum Discussion
How to visualize Microsoft Graph API data in PowerBi?
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.Contents or OData.Feed functions, 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.