Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You cannot access a PowerPivot workbook as a data source in Excel 2010

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

View products that this article applies to.

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.

↑ Back to the top

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

↑ Back to the top

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:
    Using PowerPivot Workbooks from a Mid-Tier Server Configured for Kerberos Authentication
  • 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:
    http://www.microsoft.com/en-us/download/details.aspx?id=26728
  • 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.

↑ Back to the top

Keywords: KB2712071, kbsurveynew, kbexpertiseinter, kbpivottable, kbkerberos, kbprb

↑ Back to the top

Article Info
Article ID : 2712071
Revision : 1
Created on : 12/3/2012
Published on : 12/3/2012
Exists online : False
Views : 458