Powerpivot 2013 error for getting sharepoint lists data in excel 2013 RRS feed

  • Question

  • I use powerpivot for sharepoint 2013 in my environment.

    My DBServer is separated from app server.

    I configure powerpivot for http://MyServer:83

    But when I go to excel and use powerpivot to get data from connect to data feed with this URL: http://MyServer:83/_vti_bin/ListData.svc then I get the error is shown below:

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

    I have this error only for this port, when I connect to port 84 everything is OK.

    Saturday, May 24, 2014 9:01 AM