SharePoint: Request failed: _api/contextinfo

[Ray_Brosius]

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]

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