Unable to Connect; Details: "Access to the resource is forbidden."

[Anonymous]

Hi All,

I am tying to connect to a SharePoint Online list or OData Feed via the Power BI desktop but keep getting an "Access to resource is forbidden" see below:

I have tried to use Winodws, or Organizational Account for permissions, but none of it works. I know my user credentials has access to the site, is there anything else I should be looking at?

Thanks.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

As tested, this error will be reported if the credential is wrong.

1. File->Option and settings->Data source settings->Clear Permissions

2. Reconnect to SharePoint Online List.

The account you should use is SharePoint Online's login account.

Best regards,
Lionel Chen

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

[amitchandak]

Refer to this solution on a similar issue

https://community.powerbi.com/t5/Desktop/Sharepoint-Folder-quot-Access-to-the-resource-is-forbidden-...

[Greg_Deckler]

Difficult to say, can you post Advanced Editor code? If it is SharePoint Online, you should be using the SharePoint List or SharePoint Folder connector and using OAuth (Organizational Account).