Connect Microsoft Graph query in Power Bi

[LouieG]

Was looking for a way to import Microsoft graph query as data into Power Bi. and we have already tried the following two ways:

1. In OData feed, input Microsoft graph query (e.g. https://graph.microsoft.com/beta/users), but gets response "access to the resource is forbidden"
2. There are posts suggests to use "microsoft graph security (beta)". However, we did not find it in the list of "Get Data" panel

So we wonder what is the official or suggested method to connect Mirosoft graph and Power Bi

Btw, we was trying to use MS graph to get data about risk users in Azure

[ChrisAtMAF]

Hi,

The current 'accepted solution' to this question no longer works, but I have written this article which does (although NB unsupported!)

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

[OneWithQuestion]

I'm having the same issue, they depreciated calling Graph API now via Power BI.

However, they talk about using Graph Connect or Graph Data Connect instead and Data Factory to run the query and store the results somewhere PBI can access it.

I haven't figured out how to make that a reality yet though sadly.

[dhruvinushah · Accepted solution]

Hi @LouieG , 
Refer @v-yingjl 's excellent solution to a related question: Solved: Pulling in Graph Microsoft api into powerbi - Microsoft Power BI Community
You should be able solve your connection issue using the resources provided in their answer. 

Hope this helps!