An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: PowerPivot Data
This error occurs if you query PowerPivot data on a server that does not have PowerPivot for SharePoint installed. It also occurs if the SQL Server Analysis Services (PowerPivot) service is stopped, or if you are attempting to view PowerPivot data from an earlier version.
Details
Applies to |
PowerPivot for SharePoint |
Product Version |
SQL Server 2008 R2, SQL Server 2012 |
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: PowerPivot Data |
Explanation
Excel Services returns this error when you query PowerPivot data in an Excel workbook that is published to SharePoint, and the SharePoint environment does not have a PowerPivot for SharePoint server, or the SQL Server Analysis Services (PowerPivot) service is stopped.
The error occurs when you slice or filter PowerPivot data when the query engine is not available.
User Action
Install PowerPivot for SharePoint or move the PowerPivot workbook to a SharePoint environment that has PowerPivot for SharePoint installed. For more information, see PowerPivot for SharePoint Installation (SharePoint 2010).
If the software is installed, verify that the SQL Server Analysis Services (PowerPivot) instance is running. Check Manage services on server in Central Administration. Also check the Services console application in Administrative Tools.
For PowerPivot workbooks that were created in a SQL Server 2008 R2 version of PowerPivot 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.