Thursday, July 18, 2013

Installing PowerPivot for SharePoint 2013

This blog is part of Series : Comprehensive SharePoint 2013 Development Environment Installation and Configuration


This blog article discusses how to install PowerPivot for SharePoint 2013, assuming you have followed prior steps in this series of blogs to establish SQL Server and SharePoint 2013 Farm.  This blog is now updated for SQL Server 2012 SP1.


Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1) (

Install Analysis Services Server in SharePoint Mode for SharePoint 2013 (SQL Server 2012 SP1) (


Ensure Excel Service Account access to PowerPivot Analysis Services

From the SQL Server Management tool connect to PowerPivot mode Analysis Services instance>Properties>Security>Add your Excel Services Account

Update Excel Services with PowerPivot Analysis Services

From the Central Administration>Manage Service Applications>Your Excel Service Application>Data Model Settings>Add Server

Here find out the Analysis Services installed in the PowerPivot mode in the step 7.SQL Server 2012 and BI Components Installation and Configuration  DC\POWERPIVOT


Verify your Excel Services integration with PowerPivot Analysis Services

If you already have an advanced workbook with slicers or filters, you can upload it to your SharePoint document library and verify you are able to interact with the slicers and filters from the document library view.

Install PowerPivot

Run spPowerPivot.msi to install the PowerPivot for SharePoint 2013 Configuration tool, SharePoint solution files, and data providers.

Log on to SP2013WFE server as SPSetup , load the SQL Server 2012 with SP1 Install media.

Locate the SPPowerPivot.msi under the following folder:


Run the MSI




Configure PowerPivot for SharePoint

On the server where PowerPivot to run (APP1) locate the PowerPivot for SharePoint 2013 Configuration tool


Run the PowerPivot for SharePoint 2013 Configuration tool to deploy and configure the PowerPivot features in SharePoint.




From the SQL 2012 and BI Components install we had already installed an Analysis Services in PowerPivot mode. We need this instance name next:



Click on Validate


Click on Run







At this stage go ahead and install the SPPowerPivot.msi on all other servers (SP2013APP1 and SP2013APP2) but no need to configure, followed by

IISReset on all servers.


jvalle said...

Hi, i need help, i'm installing PowerPivot for SharePoint 2013, but when i try to Run the PowerPivot for SharePoint 2013 Configuration appear this error "powerpivot for sharepoint 2013 configuration is missing prerequisites: sharepoint 2013 enterprise edition is required".

Thank you for any help.

Rajesh Agadi said...

Hello Jvalle,

Looks like the product key you have entered while installing your SharePoint 2013 is of Standard Edition.

If this is development/test environment, then from your MSDN account get the SharePoint 2013Enterprise Edition Key. If this is production environment, then purchase the Enterprise Edition license.

Once you have the above appropriate Enterprise Edition key, go back to your SharePoint server and the SharePoint setup, choose to enter product key option and now enter the enterprise key and complete the install.

Hope this helps.


jvalle said...

Hi Rajesh Agadi

Thank you for your answer, i have SharePoint 2013 15.0.4420.1017, What version i need of SharePoint 2013 to implement BI.

Rajesh Agadi said...


It is not the Version that matters for BI.

It is the Enterprise Edition of the SharePoint.

What you have is a Standard Edition.

Review the Product Key where you got it from and review my earlier answer.


jvalle said...

Hi Rajesh

I trying to change the Licence for SharePoint, Apear
Current Licence "SharePoint Server with Enterprise Client Access License", and when i try to change the Product key the text box is disabled

Rajesh Agadi said...

Hi Jvalle,

That sounds like you do have Enterprise SharePoint already installed.

What version of SQL Server install media are you using to install the PowerPivot? and the Service Pack/CU?


jvalle said...

Rajesh the version is

11.0.3000.0 SP1 Business Intelligence Edition (64-bit)

jvalle said...

Hi Rajesh, in which server must be installed powerpivot in sharepoint or sql server

Rajesh Agadi said...

Hi Jvalle,

There are two components to this:

1. Reference my other blog to install a SQL Server Analysis Services instance of PowerPivot

2. Then reference this blog to ensure you install and configure the PowerPivot components in the SharePoint farm.

Hope this clarifies.


jvalle said...

Hi Rajesh

Thank You for your help, was so appropriate, i solved the problem, I was installing the plugin on the wrong server.

thank you very much for your valuable help, if I can support on something my email is Jonathan.Valle @

Anonymous said...

Hi Rajesh:

Thanks for this. Question: I am trying to install the BI components on a SP 2013 farm that has its central admin installed using a SQL 2008 R2 backend. I want to get the BI installed by installing a new site collection on this farm using SQL 2012 SP1 for the content db and also for the analysis and reporting instances. This is possible right? now I am also a little confused on what gets installed where. I can install all of these SQL 2012 SP1 instances (SQL powerpivot, analysis for sharepoint, reporting for SP) on the backend server not on my app/WFEs right?

Rajesh Agadi said...

Hello Anonymous (SQL 2012 SP1 question above)

Yes to all:

You can let your current farm CA, existing web apps and sites all let live their databases in the existing SQL 2008 R2.

You can install a new SQL 2012 SP1 to deploy the BI Components such as all flavors of Analysis Services (and SSRS) like described in this blog.

But the for the stuff that needs to be installed on SharePoint farm servers will still need to installed on the respective SharePoint farm servers. What goes on your new SQL 2012 SP1 is the All the SQL Server installs that I had mentioned.

Finally when you configure Excel Service for PowerPivot, you should point to the new SQL 2012 SP1 PowerPivot instance.

Hope this clarifies.


Rajesh Agadi said...

And another comment for the above question. You can place your new Site Collection Content DB in either SQL Server database, provided you also install the DB Engine on the SQL 2012 Sp1 instance.

Anonymous said...

Hi Rajesh ,

Very helpful post. What does it mean if i don't see the manage Data refresh option on the Excel file uploaded to Sharepoint 2013 ?


Unknown said...

Hi Rajesh,

Do we require to install SPPowerPivot.msi on WFEs too?

Please let know.


Unknown said...

Hi Rajesh,

Do we need to install SPPowerPivot.msi on WFEs on multi server deployment?


Rajesh Agadi said...


Yes, you will have to install the SPPowerPivot.msi on all servers, all WFEs all APP Servers as well.


Unknown said...

Thanks Rajesh.

Pabolu said...

Hey Rajesh ,

First of all very nice Article,

This is my Question, I have 2 WFE's( Load balance in place) 1 APP server and 1 Search server can you guide me how to configure the Power pivot.