Connection to SharePoint fails

[Anonymous]

Hi,

My Power BI has recently stopped connecting to my SharePoint.

I definitely have all rights in the SharePoint.

I have tried the following scenarios and got these results:

1. log in via SharePoint Connector with organization account and root URL
I get an empty display/table.

2. access SharePoint via Web Content Connector with organization account
Error message: "Authentication could not be performed with the specified credentials. Please try again."

3. delete the permissions in data source settings and specify them again. (all correct)
Error message: "Connection not possible: Access to the resource is prohibited".

4. entire URL to SharePoint folder specified
Error message: "Connection not possible: Not found - Microsoft.Mashup.Engine1.Library.Resources.HttpResource:"

What is strange is that in an older PowerBI report, the connection works. I once deleted the permissions in the data source settings and granted them again. Everything works here and Power BI gets the right data.

What can I do? Please help.

Thanks.

[Syndicate_Admin]

I solved it by creating a new connection to the same table and this updated the credentials of the previous connection.

I solved it by creating a new connection to the same table and this updated the credentials of the previous connection.

[Icey]

Hi @Anonymous ,

I am curious if you have solved this problem.

If it is solved, can you share your solution with us? Or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please share us more details.

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

Is the URL you used like so: https://yourcompany.sharepoint.com/sites/yoursubsite ?

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , See if these common solytion can help

sharepoint access forbidden
https://rukiatu.com/access-to-resource-is-forbidden/
https://community.powerbi.com/t5/Desktop/Get-Data-sharepoint-folder-issue/td-p/586727
https://community.powerbi.com/t5/Desktop/Expression-Error-Access-to-the-resource-is-forbidden-sharepoint/m-p/768278
https://community.powerbi.com/t5/Desktop/Access-to-the-resource-is-forbidden/m-p/366485

https://sharepoint.stackexchange.com/questions/65902/listdata-svc-gives-a-500-error-when-querying-some-lists