Pulling in Graph Microsoft api into powerbi

[Anonymous]

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

[nicoleannep]

I made a comprehensive guide for this specifically for M365 License Usage

0 Game Plan - networkgirlie - Obsidian Publish

[ChrisAtMAF]

You can also use this method - I created a step by step guide, and it does work 🙂

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

[v-yingjl · Accepted solution]

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:

• How to get Microsoft Graph API data on Microsoft Power BI 
• How to get Microsoft Graph API Data  

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.