Getting an access token for Microsoft Graph

[JohnFabric]

Hello, I'm trying to connect PowerBI to https://graph.microsoft.com but can't seem to figure out how to. There are a couple of old solutions on this forum that say you need to create a custom data connector but all the solutions are marked are deprecated or 404 now. What is the current approved way to hook these services together?

[hnguy71]

1. Azure app registration with graph permissions
2. From Power BI use web connector. Connect as anonymous
3. pull graph api data 

Should still be the same process.

[JohnFabric]

Is there a how to to do that? I've not done that before. I do see that direct query isn't recommend (https://learn.microsoft.com/en-us/power-query/connecting-to-graph) but I'm not sure I need the entire overhead of (https://learn.microsoft.com/en-us/graph/overview#access-microsoft-graph-data-at-scale)

[hnguy71 · Accepted solution]

Hi @JohnFabric 

These two articles should work. From the first link, follow the steps to creating an app registration. From the second link, all of it should be relevant for you.

1. Creating an app registration: https://sharepains.com/2023/01/03/microsoft-graph-api-the-power-platform

2. Querying and refreshing graph api from Power BI: https://www.linkedin.com/pulse/story-powerbi-microsoft-graph-api-service-side-refresh-journaux

[JohnFabric]

Great thank you! I'll give that a try

[Anonymous]

Hi @JohnFabric ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards