Forum Discussion
Pulling in Graph Microsoft api into powerbi
Hi there,
Is there an official way of pulling in data from https://graph.microsoft.com/.. into PowerBi..? In my case it's (https://graph.microsoft.com/beta/servicePrincipals) etc.
I get the 'unable to connect' prompt when connecting via the 'odata feed'. However I am able to veiw the data in graph-explorer.
Other then that I see lots of workaround.
Many thanks
Hi Anonymous ,
Currently there are multiple ways to connect to Graph Microsoft api in power bi that you can refer:
1. About using OData feed, please refer this video and aritcle:
If it has some issues, you can refer this article to check: Workaround to connect Power BI to Microsoft Graph
2. About using Logic Apps, please refer this article: Use Graph API data in Power BI using Logic Apps
3. In addition, you can try to create custom connectors to connect it, please refer this blog:
Microsoft Graph API Custom Connector for Power BI
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
v-yingjlCommunity Support
Hi Anonymous ,
Currently there are multiple ways to connect to Graph Microsoft api in power bi that you can refer:
1. About using OData feed, please refer this video and aritcle:
If it has some issues, you can refer this article to check: Workaround to connect Power BI to Microsoft Graph
2. About using Logic Apps, please refer this article: Use Graph API data in Power BI using Logic Apps
3. In addition, you can try to create custom connectors to connect it, please refer this blog:
Microsoft Graph API Custom Connector for Power BI
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.You can also use this method - I created a step by step guide, and it does work 🙂
I made a comprehensive guide for this specifically for M365 License Usage
