Connecting to Graph API with Power BI

[jasonyeung87]

HI,

I'm trying to obtain a list of users with the Graph API with Power BI. The URL I'm using is https://graph.microsoft.com/v1.0/users and I'm following the steps from https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb... to connect. But I'm getting the following error when I tried to connect with Power BI Desktop:

I tried to use a custom connector (example is at https://github.com/cristianoag/PowerBIGraphCustomConnector). It prompted me to sign in, but I'm getting the error below:

I searched around to see whether I could find another way or if something else I need to do, but I couldn't find anything. I was wondering if there's another way to connect to Graph API with Power BI? Or if there's an extra step I missed when I used the 2 techniques above.

Jason

[Anonymous]

Hi @jasonyeung87 ,

1. Double-check that you have followed the steps in the blog to create a new application in Azure Active Directory and configure access permissions for it.
Use the Microsoft Graph API - Microsoft Graph | Microsoft Learn
Register your app with the Azure AD v2.0 endpoint - Microsoft Graph | Microsoft Learn
Get access on behalf of a user - Microsoft Graph | Microsoft Learn
List users - Microsoft Graph v1.0 | Microsoft Learn

2. Consider using AAD/master user auth instead.
Solved: Power BI REST API gives 403 forbidden (use service... - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum