in SharePoint 2010

PowerPivot for SharePoint 2010


If you are planning to install PowerPivot for SharePoint 2010, then there are two ways to install:


1) Installing to an existing SharePoint 2010 farm


2) Installing to a new SharePoint 2010 farm


I always find (myself and) more people fall in the first category where there already exists SharePoint 2010 farm.


Some things to note 


1) PowerPivot strictly requires SQL Server 2008 R2

2) PowerPivot works with x86 Office client, which  means, you don’t have to install PowerPivot x64 just because SharePoint 2010 and SQL Server 2008 R2 is x64


Installation Docs


MSDN has excellent posts on how to install PowerPivot. If you follow the MSDN documentation word by word, I can assure you that you will succeed without any pains installing and configuring PowerPivot for SharePoint. (other than the only issue which is discussed later in this blog post):


1) How to: Install PowerPivot for SharePoint on a New SharePoint Server


2) How to: Install PowerPivot for SharePoint on an Existing SharePoint Server


Cannot load or locate Microsoft.AnalysisServices.SharePoint.Integration.DLL assembly

After installation, you can get an error which says SQL Installation was successful but could not load or locate Microsoft.AnalysisServices.SharePoint.Integration.DLL assembly


The only solution is as follows:


1) Navigate to the folder: C:Program FilesMicrosoft SQL Server100SDKAssemblies

2) Copy the Microsoft.AnalysisServices.SharePoint.Integration.DLL to another folder

3) Uninstall SQL Server 2008 R2 PowerPivot Instance

4) Copy the Microsoft.AnalysisServices.SharePoint.Integration.DLL to GAC

5) Install SQL Server 2008 R2 for PowerPivot


I do know this is a known issue and there will be a fix/update soon.

Write a Comment