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

Symptoms
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.
Cause
This issue occurs when the request to authenticate the user account cannot be made through the PowerPivot redirector service: 
/_vti_bin/PowerPivot/Redirector.svc
Resolution
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.
powerpivot sharepoint xl2010 xl14
Properties

Article ID: 2712071 - Last Review: 12/03/2012 21:46:00 - Revision: 1.0

Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010, Excel Services in Microsoft SharePoint Server 2010, PerformancePoint Services in Microsoft SharePoint Server 2010, Microsoft Excel 2010

  • kbprb kbkerberos kbpivottable kbexpertiseinter kbsurveynew KB2712071
Feedback