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


Applies To: SQL Server 2016

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

Applies toPower Pivot for SharePoint
Product VersionSQL Server 2008 R2, SQL Server 2012, SQL Server 2014
CausePowerpivotwebapp solution is not deployed or did not deploy correctly.
Message TextCould not load file or assembly 'Microsoft.AnalysisServices.SharePoint.Integration'

Power Pivot 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 Power Pivot Gallery or other Power Pivot 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.

Deploy Power Pivot Solutions to SharePoint

Community Additions