Using OData Feed with SharePoint

[irina_l]

I want to use OData Feed connection to get data from my sharepoint site. When I connect to root site collection it works perfectly, but it's impossible connect to any site which is not a root site collection.
http://myserver/_vti_bin/ListData.svc - works
http://myserver/sites/anysite/_vti_bin/ListData.svc - doesn't work

DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: 
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)
Details:
    DataSourceKind=OData
    DataSourcePath=http://sp2016/sites/rem/_vti_bin/ListData.svc
    SPRequestGuid=a44cdb9d-a582-103c-70f3-9827ef1368d7, a44cdb9d-7585-103c-70f3-9dab4bbc9ad2, a44cdb9d-1588-103c-70f3-9bdac7542290

[v-haibl-msft]

@irina_l

The product team has looked into the fiddler traces provided by you.

The bug in SharePoint is in the xml:base element of the last request in the Fiddler trace to return a 200. It says xml:base="http://lisovskaya-i/_vti_bin/Elearningforce/Dashboard/Data.svc/". Based on the original URL, this value is not correct. The actual xml:base should probably have been "http://lisovskaya-i/sites/rem/_vti_bin/Elearningforce/Dashboard/Data.svc/". You'll need to find out from the SharePoint team how this error can happen on their side.

Best Regards,

Herbert

[irina_l]

@v-haibl-msft

may be you are right, may be it's sharepoint issue. I am only confused why it can work in Power Pivot in excel - it connects to correct URL, it receives correct result...

[abinashphuel]

In my case I found that this error occur because there was (already) stored permission in the system (With some type and credentials), when I try to reconnect with that or use new link it try to use old permission. So either edit old permission or delete old permission.

1. Go to File>Option and Setting > Data source setting
   Then there are two options
2. (Option1) Select the data source then click on Edit Permission
   1. edit the permission as required in most cases use Type basic
3. (Option 2) select the data source and delete/clear the permission
   1. Then connect data source again

 Remove the cache from Options this will solve the problem. 

For this go to File>Options>DataLoad and clear Cache.

Hope this will help you! 🙂