Query MS Graph API

[shocko]

Is there a guide on retrieving MS Graph API data in PowerBI?

[ChrisAtMAF]

You might also want to try this guide:

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

[v-yiruan-msft]

Hi @shocko ,

Hope the following documentations can help you:

https://www.youtube.com/watch?v=mCwCVbW6-Ww

https://zappysys.com/blog/get-office-365-data-in-power-bi-using-microsoft-graph-api-and-odbc/

https://community.powerbi.com/t5/Desktop/Use-Microsoft-Graph-API-as-data-source/td-p/640426

Best Regards

Rena

[shocko]

Thanks for the links! Seems like powerBI should have a native connector for Azure and MS Graph no? Is there somewhere to create feature requests?

[v-yiruan-msft]

Hi @shocko ,

You can check the details of connector in following documentations:

https://github.com/Microsoft/DataConnectors/tree/master/samples/MyGraph

https://docs.microsoft.com/en-us/power-query/samples/mygraph/readme

https://prathy.com/2017/11/access-microsoft-graph-api-using-power-bi/

Best Regards

Rena

[Cristian_Angyal]

Hi @shocko ,

You should check this article: https://blog.mydock365.com/microsoft-graph-api-data-on-microsoft-power-bi

It might be just what you're looking for.

If you liked my solution please give it a thumbs up 👍. 

If I did answer your question please mark my post as a solution ✅.

Thank you !

Cristian

[JanBakker]

Bummer, OData doesnt working with Graph API anymore.😐

Try this: https://janbakker.tech/2020/05/09/use-graph-api-data-in-power-bi-using-logicapps/