Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

RESOLVED SharePoint gateway issue OData Version: 3 and 4, Error: The remote server returned an error

As of July 1, 2020 the dataflows that connected to on-prem SharePoint 2010 lists through a gateway were no longer working for our company.
 
I thought it might have been a username/password issue but that did not help.
 
The error that occurs everytime our scheduled refresh runs is:
 
An exception occurred: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: 
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (NOT FOUND)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (NOT FOUND)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (NOT FOUND) (Session ID: 6c8dbed0-ba7d-4c87-9c92-736bbd4d0193)
 
I updated the gateway software to the latest version and that still did not help!!
 
solution:
 
Finally, I decided to test a connection to SharePoint from Power BI desktop and it worked.  I noticed that the connection worked but looked a little different than the connection on Power BI Online when viewed using Advanced Editor
 
It looks like the initial connection in power query was somehow updated from version 14 to version 15:
 
Source = SharePoint.Tables("http://sharepointroot/mysubsite", [ApiVersion = 15])
 
After I changed the 15 back to 14 everything started working again.
 
If you are experiencing the same problem, double-check your ApiVersion and make sure it hasn't been updated.
7 REPLIES 7
chewbie
New Member

How to change ApiVersion

Oleg31
New Member

There may be another problem related to authorization on a SharePoint folder or file.
I had this problem when I changed the rights for the member group from RW to R. When I restored the rights to RW, this error disappeared.

CristianGiraldo
New Member

Spanish

 

Hola, tuve el mismo error, lo resolvi de la siguiente forma como una solucion temporal, no es una solucion tecnica:

 

1- Descargue de la ruta sharepoint una copia del archivo a mi disco duro, y conecte el documento a Power BI de forma local.

2- Una vez conectado el archivo de forma local, procedi a cambiar el origen de los datos desde Power Query pero esta vez pegando la ruta del archivo que esta en sharepoint, la cual estaba generando el problema con el conector de "Carpeta Sharepoint".

 

Descargue el Archivo Local y luego hice lo de la Imagen.PNG

 

y listo, cierro y actualizo y el archivo queda conectado al origen de datos desde sharepoint

Anonymous
Not applicable

Hi 

 

I am getting the same error - is there any resolution ? My URL works fine if I click on it. I am trying to connect to a folder in Sharepoint to pick up a file 

 

Details:Unexpected exception in query "<pi>Query</pi>", Message: <pi>DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found) OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found) OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)</pi>

 

Thanks

 

 

Anonymous
Not applicable

Hi!

Switching API to 14 helped with removing the OData errors.

But now I have this error instead.. 

Tiber14_0-1661865161971.png

 

What would the solution be for this? 

have you fixed this? I have the same errors

v-alq-msft
Community Support
Community Support

Hi, @Anonymous 

 

I wonder which connector you are using to connect to sharepoint sites. Sharepoint is a cloud service which you don't need a gateway to connect to. The on-premises data gateway acts as a bridge. It provides quick and secure data transfer between on-premises data, which is data that isn't in the cloud, and several Microsoft cloud services. 

 

 

I tested with 'sharepoint folder'

d1.png

 

d2.png

 

d3.png

 

It works properly. My [ApiVersion] is 15. If the issue still exist, you may create a support ticket here .

 

Best Regards

Allan

 

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors