Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: Power Pivot Data

An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: Power Pivot Data

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

This error occurs if you query Power Pivot data on a server that does not have Power Pivot for SharePoint installed. It also occurs if the SQL Server Analysis Services (Power Pivot) service is stopped, or if you are attempting to view Power Pivot data from an earlier version.

Applies to

Power Pivot for SharePoint

Product Version

SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

Cause

The data connection failed.

Message Text

An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: Power Pivot Data

Excel Services returns this error when you query Power Pivot data in an Excel workbook that is published to SharePoint, and the SharePoint environment does not have a Power Pivot for SharePoint server, or the SQL Server Analysis Services (Power Pivot) service is stopped.

The error occurs when you slice or filter Power Pivot data when the query engine is not available.

Install Power Pivot for SharePoint or move the Power Pivot workbook to a SharePoint environment that has Power Pivot for SharePoint installed. For more information, see Power Pivot for SharePoint 2010 Installation.

If the software is installed, verify that the SQL Server Analysis Services (Power Pivot) instance is running. Check Manage services on server in Central Administration. Also check the Services console application in Administrative Tools.

For Power Pivot workbooks that were created in a SQL Server 2008 R2 version of Power Pivot for Excel, you must install the SQL Server 2008 R2 version of the Analysis Services OLE DB provider. This error will occur if you installed the provider, but did not register the Microsoft.AnalysisServices.ChannelTransport.dll file. For more information about file registration, see Install the Analysis Services OLE DB Provider on SharePoint Servers.

Community Additions

ADD
Show:
© 2015 Microsoft