Access to Resource Forbidden Error with Graph API Connector in Power BI

[baldeep93]

Hello Power BI Community,

I am encountering an issue with the Graph API connector when using the Web connector in Power BI. Specifically, when I try to pass https://graph.microsoft.com/v1.0/users/, I receive an error stating that "Access to the resource is forbidden."

Here are the details of my setup:

• I have a Microsoft developer account.

• I created a fictitious company with 10 users.

• I want to fetch user details in Power BI using the Graph API.

Interestingly, I do not encounter this error when using the same API endpoint with the Office365Groups connector in Power Apps. For example, the following code works without any issues in Power Apps:

Set(colusers, Office365Groups.HttpRequest("https://graph.microsoft.com/v1.0/users/", "GET", ""))

Do i need to do an app registeration in Azure and if yes then which all persmissions do i need to grant to the app so that i can bring the data in Power Bi ?

Because I am able to bring the data in Power apps and I dont know if i registered an app or it is a default thing that happens with my profile

[Anonymous]

Hi @baldeep93 ,

We need an app registration in Azure AD to authenticate to Graph API. Create the app registration and add the right permissions. To see what permissions you’ll need, head over to the Graph API reference.  Don’t forget to grant admin consent after you applied the permissions.

More detailed information can be found at the link：Use Graph API data in Power BI using Logic Apps - JanBakker.tech

you can refer this article to check: Workaround to connect Power BI to Microsoft Graph 

 In addition, you can try to create custom connectors to connect it, please refer this blog:

Microsoft Graph API Custom Connector for Power BI 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[baldeep93]

What all permissions do i need to grant to the app and after making a connection in Power Bi using Web Connector, how do i change the credentials from my account to the app account ?