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

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

Details

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'

Explanation

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.

User Action

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.

See Also

Tasks

Deploy PowerPivot Solutions to SharePoint