SharePoint By Yagya Shree

Posts Tagged ‘odata

SharePoint 2013: _vti_bin/listdata.svc

leave a comment »


ISSUE:

When trying to create a data source connection in excel 2010 to connect to SharePoint list, We are getting below error in Excel:

https://<site>/_vti_bin/listdata.svc

PowerPivot For Excel

Cannot connect to specified feed. Verify the connection and try again. Reason: The remote server returned an error: (401) Unauthorized.

listdata

When we tried the same wcf connect in Chrome, We got below message:

HTTP 500

The Webpage can not be displayed

 

RESOLUTION:

  • It was identified that in the one of the list had a column name with special character i.e.(# ; : ) 
  • We renamed the column name without any specific characters
  • Tried the WCF connect again and it worked.

 

Refer: https://blogs.technet.microsoft.com/victorbutuza/2014/06/30/why-would-listdata-svc-return-an-error/

Advertisements

Written by Yagyashree

September 15, 2016 at 9:54 pm

Posted in sharepoint

Tagged with , , , , ,

%d bloggers like this: