PowerPivot does not send authentication header in basic authentication in OData Svc

Question

QA - I know the answer.

I created the OData endpoint of the WCF data services and all of its work, PowerPivot connects, and I created some pivot tables.

Then I implemented the HTTP Basic Authentication handler, which challenges requests not represented by an authentication header with 401 WWW authentication, see link:

http://www.asp.net/web-api/overview/security/basic-authentication

This works for IE; the browser displays a credential input dialog, and IE continues to attach a header with subsequent requests, caches it.

In Excel, I see that it sends an authorization header in response to the initial call, but it does not cache credentials and does not send the header on the next request.

Everything is installed in accordance with PowerPivot instructions.

Answer 1

When setting up a data source / feed in PowerPivot, you need to add the trailing backslash to the URLs of the OData endpoints, e.g.

http://localhost:50885/Service.svc/

Error, but at least with a workaround, and once posted here on SO, a more easily detectable workaround!