SharePoint: Request failed: _api/contextinfo

Ray_Brosius · ‎05-12-2021

I have a Power BI dataset that reads in a large number of csv files from a SharePoint Site. I have it refresh only once a day. the refresh fails almost everyday now.. it runs perfectly fine on my desktop .. There is a single file in this folder... I am using the out of the box SharePoint FOlder connector to read in files from this folder and several others. The other folders have a lot of files and I combine them all...

The error is not consistent, in that sometimes I just restart the refresh and it works...

Hide

Scheduled

5/12/2021, 6:02:45 AM

5/12/2021, 6:20:32 AM

Failed

There was an error when processing the data in the dataset.

Processing error:	SharePoint: Request failed: https://OURSITE.sharepoint.com/sites/SITENAME/Shared Documents/Owner_Data/Owner_Data0_csv/_api/contextinfo
Cluster URI:	WABI-WEST-US-redirect.analysis.windows.net
Activity ID:	f88e5ae3-feec-4548-a7d4-fd5eb8eca19f
Request ID:	a3dfaf29-0d71-4217-b7e4-fd0661e98e11
Time:	2021-05-12 10:20:32Z

v-deddai1-msft · ‎05-13-2021

Hi @Ray_Brosius ,

I can't reproduce your issue. Would you please try to clear the SharePoint credentials in power bi desktop and recreate it again? (File->Options and Settings->Data Source Settings->Clear Permission)

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

Best Regards,

Dedmon Dai