Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Analysis Services
Technical Reference
Errors and Events Reference (PowerPivot for SharePoint)
An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: PowerPivot Data
Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration'
Could not load file or assembly 'Microsoft.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
The data connection path in the workbook points to a file on the local drive or is an invalid URI. The following connections failed to refresh: PowerPivot Data
The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh: PowerPivot Data
The following features are not supported by Excel Services and may not display or may display only partially: Comments, Shapes, or other objects
The trusted location where the workbook is stored does not allow external data connections. The following connections failed to refresh: PowerPivot Data
This workbook contains one or more queries that refresh external data.
Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: PowerPivot Data
Expand Minimize
1 out of 2 rated this helpful - Rate this topic

Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration'

SQL Server 2012

In SharePoint 2010 environments that have PowerPivot for SharePoint, this error will occur if the application-level solution for PowerPivot did not deploy correctly.

Applies to

PowerPivot for SharePoint

Product Version

SQL Server 2008 R2, SQL Server 2012

Cause

Powerpivotwebapp solution is not deployed or did not deploy correctly.

Message Text

Could not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration'

PowerPivot for SharePoint uses solution packages to deploy its features on a SharePoint server. One of the solutions is not deployed correctly. As a result, this error appears whenever you try to open PowerPivot Gallery or other PowerPivot application pages on a SharePoint site.

Deploy the solution package.

  1. In Central Administration, in System Settings, click Manage farm solutions.

  2. Click Powerpivotwebapp.

  3. Click Deploy Solution.

  4. Choose the web application for which this error is occurring. If there is more than one web application, redeploy the solution for all of hem.

  5. Click OK.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.