DataSource.Error: Sharepoint: Request failed

[SuperFiets_]

Hi everyone,

I am struggling with an issue with my Sharepoint connection in Power BI.

With the function: Sharepoint.Files I am collecting data from the documents folder on my site.

People upload files in the sharepoint document folder for my analysis to run it.

However I am constantly running into the following error: 

DataSource.Error: SharePoint: Request failed: (Sharepoint site)/_api/contextinfo

For some reason Power BI stops loading in the data and just returns an error.

How can I fix this problem? Is there a way to adjust the request time for getting Sharepoint files.

Thanks in advance!

[Anonymous]

Hi @SuperFiets_,

Have you worked with a single SharePoint datasource or mixed multiple datasource from different SharePoint sites? If you mean the second one, current power bi can only save one authorization credential from the same data source type.

For this scenario, the newly added datasource credentials will replace the old credentials. Then they may break the datasourceverify due to new credentials not matching with the old datasource.
Regards,

Xiaoxin Sheng

[amitchandak]

@SuperFiets_ , Try clear credentials and try again

File->Options and Settings->Data Source Settings->Clear Permission

[SuperFiets_]

Have tried that already, but didn't change anything.