You cannot access a PowerPivot workbook as a data source in Excel 2010


In Microsoft Excel 2010, when you try to connect to a PowerPivot workbook as a data source on a Microsoft SharePoint Server 2010 share, you receive the following error: 
Unable to connect to data source.

Reason: Access denied. You either made a mistake typing in your User ID and/or Password, or you do not have permission to access the database server.


This issue occurs when the request to authenticate the user account cannot be made through the PowerPivot redirector service: 


To resolve this issue, use one of the following methods, as appropriate for your situation:
  • The web application is set up to use the Kerberos authentication method. In this case, follow the steps in this MSDN article:
  • The client that makes the call to the PowerPivot workbook does not have updated Microsoft Analysis services OLE DB drivers. Download the latest Analysis services drivers from following Microsoft Download Center website:
  • The web application where the PowerPivot workbook is stored has multiple bindings in Internet Information Services (IIS). In this case, follow these steps:
    1. Open IIS, select the SharePoint web application, and then click Bindings.
    2. If more than one binding is listed, delete the additional bindings. 
  • The PowerPivot workbook is stored at the site collection level on the SharePoint server. In this case, the user account that makes the connection has to have access to the Root Web application.

文章識別碼:2712071 - 最後檢閱時間:2012年12月3日 - 修訂: 1