Forum Discussion
Getting an access token for Microsoft Graph
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?
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
5 Replies
- Azure app registration with graph permissions
- From Power BI use web connector. Connect as anonymous
- pull graph api data
Should still be the same process.
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)
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
