none
Power Query error 400 when getting data from SP2010 RRS feed

  • Question

  • Hello,

    we've got one SharePoint 2010 farm with 2 web applications : one with anonymous access enabled, the other without. We performed several tests with Power Query for Excel 2013 (data source : Sharepoint List) :

    - no problem with the sites/subsites/lists within the non-anonymous web application

    - error 400 when accessing sites/subsites/lists within the anonymous enabled web application (event when anonymous users are not allowed on these sites)

    Findings :

    - Access via IE is OK on both webapps : http://<server>/sites/<site>/_vti_bin/ListData.svc/<list>

    - Selected credentials in Power Query : Windows

    - Fiddler traces for anon webapp (but non-anon site) : 

    HTTP/1.1 400 Bad Request
    Cache-Control: private
    Content-Type: text/html
    Server: Microsoft-IIS/7.5
    SPRequestGuid:  
    X-SharePointHealthScore: 0
    X-AspNet-Version: 2.0.50727
    X-Powered-By: ASP.NET
    MicrosoftSharePointTeamServices: 14.0.0.6117
    X-MS-InvokeApp: 1; RequireReadOnly
    Date: Tue, 28 Jan 2014 10:27:32 GMT
    Content-Length: 1165
    <?xml version="1.0" encoding="utf-8"?><HTML><HEAD><TITLE>Request Error</TITLE></HEAD><BODY>
    <DIV id="content"><P class="heading1">Request Error</P><BR/>
    <P class="intro">The server encountered an error processing the request. See server logs for more details.</P>
    <P class="intro"></P></DIV></BODY></HTML>

    - Fiddler traces for non-anon webapp : 

    HTTP/1.1 401 Unauthorized
    Server: Microsoft-IIS/7.5
    SPRequestGuid: 
    WWW-Authenticate: Negotiate
    WWW-Authenticate: NTLM
    X-Powered-By: ASP.NET
    MicrosoftSharePointTeamServices: 14.0.0.6117
    X-MS-InvokeApp: 1; RequireReadOnly
    Date: Tue, 28 Jan 2014 10:29:37 GMT
    Content-Length: 0
    Proxy-Support: Session-Based-Authentication

    Any hints ?

    thx

    Tuesday, January 28, 2014 11:25 AM

Answers

  • So you get the failure when you use Windows auth to connect to the site? Could you try (at least temporarily) enabling Basic Auth on the site and using Basic Auth with Power Query to see if that works?

    If this is a problem with SharePoint, there's not much we can do to help... :(.

    Tuesday, January 28, 2014 4:43 PM

All replies

  • The error message says "The server encountered an error processing the request. See server logs for more details". Was there anything interesting in the server logs?
    Tuesday, January 28, 2014 12:53 PM
  • Not really : usual verbose crap...

    Failed to connect to <server>:13391 Failed to initialize session with document engine: Unable to resolve Contentdistributor

    Additional findings :

    - "http://<server>/sites/<site>/_vti_bin/ListData.svc/<list>" loads successfully with IE only when previous access with IE to "http://<server>/sites/<site>/" ; this might be due to authentication being forced when loading "http://<server>/sites/<site>" and credentials being reused.

    - I found similar cases ( http://sharepoint.stackexchange.com/questions/14718/error-while-referring-vti-bin-listdata-svc ) ; workaround could be to disable anonymous access at the web app level, solution I can't afford since some sites in that web app need this option

    any help?

    Tuesday, January 28, 2014 3:17 PM
  • Could you replicate the information to a non-anonymous site for use by Power Query?
    Tuesday, January 28, 2014 3:25 PM
  • So you get the failure when you use Windows auth to connect to the site? Could you try (at least temporarily) enabling Basic Auth on the site and using Basic Auth with Power Query to see if that works?

    If this is a problem with SharePoint, there's not much we can do to help... :(.

    Tuesday, January 28, 2014 4:43 PM