PowerPivot不将基本身份验证中的授权头发送到OData Svc [英] PowerPivot not sending Authorization header in Basic Authentication to OData Svc

问题描述

QA - 我知道答案。

我已经创建了一个WCF数据服务OData端点及其所有功能，PowerPivot连接和我构建了一些数据透视表。 p>

然后，我实现了一个基本身份验证HTTP处理程序，其挑战请求没有显示授权头，具有401 WWW-Authenticate查看链接：

http://www.asp.net/web-api/概述/安全/基本认证

这适用于IE;浏览器弹出一个凭据输入对话框，IE继续附加标题与后续请求，缓存它。

在Excel中，我可以看到它发送授权头响应到最初的挑战，但它不缓存凭据并在下一个请求中发送头。

所有内容都按照PowerPivot说明进行设置。 / strong>

解决方案

在设置数据源/ Feed时，需要在OData端点URL中追加尾随的反斜杠PowerPivot，例如

  http：// localhost：50885 / Service.svc / 
  

一个错误，但至少有一个解决方法，一旦在这里发布，一个更容易被发现的解决方法！

QA - I know the answer.

I have created a WCF Data Services OData endpoint and its all works, PowerPivot connects and I built some pivot tables.

Then I implemented a Basic Authentication HTTP handler which challenges requests not presented an Authorization header with a 401 WWW-Authenticate see link:

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

This works for IE; the browser pops a credentials input dialogue and IE continues to attach the header with subsequent requests, caches it.

In Excel, I can see that it sends the Authorization header in response to the initial challenge, but it doesn't cache the credentials and send the header on the next request.

Everything is set as per the PowerPivot instructions.

解决方案

You need to append a trailing backslash to the OData endpoint URLs when setting-up the data source/feed in PowerPivot, e.g.

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

A bug, but at least with a workaround, and once posted here on SO, a more easily discoverable workaround!

这篇关于PowerPivot不将基本身份验证中的授权头发送到OData Svc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！