cancel
Showing results for 
Search instead for 
Did you mean: 

Sharepoint refresh error OLE DB or ODBC error: [DataSource.Error] SharePoint: Request failed:

In the last couple of days, I have been getting the error below randomly in Power BI Desktop as well as in Power BI service. There is no consistency when and in which query this message will occur. Once every few times, the refresh works without changing anything. It can happen in any report randomly. I have also tried on different tenants and I can see the same issue. 

 

tempsnip.png

 

Thanks

Nishant

Status: New
Comments
v-chuncz-msft
Community Support

@nishantjaincent 

 

Several issues regarding sharepoint and mashup query have been reported. You may also create a support ticket for assistance if necessary.

nishantjaincent
Advocate IV

Thanks @v-chuncz-msft . I will raise a support ticket. However, is there a way for me to check what issues are currently reported. Just want to check if my issue is a new one or someone else has already raised this issue. Also, it will help in the future to keep an eye on known issues. 

 

Nishant

melmell
Frequent Visitor

I'm experienceing the same error.

It started following the August 2020 update (Version: 2.84.661.0 64-bit & Version: 2.84.701.0 64-bit )

I have miltuple files in a SharePoint folder. The source is "SharePoint.Contents".

The query will start loading and at a random time will fail with the following error:

"OLE DB or ODBC error: [DataSource.Error] SharePoint: Request failed: [file url]/_api/contextinfo."

I tried clearing and resetting the permissions, it didn't solve the problem.

Any ideas on how to debug this will be much appreciated.