Run the "PowerPivot Configuration Tool" after Upgrading the Analysis Services POWERPIVOT Instance.


After applying an update to the Analysis Services Server running PowerPivot, you also need to upgrade the sppowerpivot.msi on the SharePoint Server running PowerPivot and re-run the PowerPivot Configuration Tool.  These two (SQL and SharePoint) need to have matching builds.  For example, if you apply the Cumulative update package 7 for SQL Server 2012 Service Pack 1 to the Analysis Services Server running PowerPivot, the build of Analysis Services will be 11.0.3393.0

If you don't upgrade the sppowerpivot.msi on SharePoint and run the PowerPivot Configuration Tool, it will indeed run, but you will see the build is 11.0.3000.0 (SP1).  No new PowerPivot files on the SharePoint server were detected.

You might ask, "Well, how do I locate and prove this is indeed the version of my sppowerpivot.msi?"  To do this, browse (on the SharePoint machine running PowerPivot) to C:\Program Files\Microsoft SQL Server\110\Tools\PowerPivotTools\SPAddinConfiguration\Bin\ and right click on PowerPivotSPAddinConfiguration.exe and choose Details.

Now the challenging question arises, "How do I update the sppowerpivot.msi?"  To answer that question, you need answer my question, "How did you originally install the sppowerpivot.msi on the SharePoint Server.  Did you apply it using the SQL Installation Center or did  you apply it via our download center?"

There is a chance you have no idea how you installed it.  Maybe you hired a consultant or maybe that employee is no longer with the company.  If you have the SQL Server Installation Center installed on that SharePoint machine and you see PowerPivot Configuration Tool under Tools, then you can go ahead and apply the CU on to that SharePoint Server.

If you don't, then you most likely applied the sppowerpivot.msi from our download center.  Below is the link to the 11.0.3000.0 (SP1) version.

Microsoft® SQL Server® 2012 SP1 PowerPivot® for Microsoft® SharePoint®
http://www.microsoft.com/en-us/download/details.aspx?id=35577

If you downloaded the sppowerpivot.msi from the above link and now need to update PowerPivot for SharePoint, things are going to get tricky (updates for the sppowerpivot.msi are available for Service Packs via our download center at the time I wrote this (see end of blog), but we have not made the updated sppowerpivot.msi for individual CUs available for download via our download center).  To update the sppowerpivot.msi, you are going to need to download the CU and extract the sppowerpivot.msi out of it.

To do this, download the CU onto your computer.  In this example we will use:

Cumulative update package 7 for SQL Server 2012 Service Pack 1
http://support.microsoft.com/kb/2772858

Choose the correct product:

You will then need to request the hotfix.  An email will be sent to you allowing you to download the hotfix.

The hotfix will look like this:

You then need to extract the hotfix, which will look like this:

If you place the above executable on the root of C:, you can run this parameter from the command line: SQLServer2012-KB2894115-x64.exe /extract:C:\temp\sql

…to extract the contents.

..this will place them in C:\temp\sql.  You will want to browse to C:\Temp\sql\1033_enu_lp\x64\setup, where you will see the sppowerpivot.msi

You can now click on it to update PowerPivot for SharePoint.  If you are on a lower version (11.0.3000.0) than SQL Server 2012 SP1 CU7 (11.0.3393.0), a lower version will be detected.

Follow the prompts to upgrade PowerPivot.

You will need to reboot the SharePoint Server:

After you do this, you can see the version of PowerPivot on SharePoint has been upgraded to 11.0.3393.0.

Now you can re-run the PowerPivot Configuration Tool:

You will see the updated version (11.0.3393.0).

Lastly, the Tool will indeed detect the new Features, Services, Applications, and Solutions that were laid down by the upgrade.

After this continue using the Tool and your install should be standardized between SQL and SharePoint.

Downloadable sppowerpivot.msi:

Microsoft® SQL Server® 2012 SP1 PowerPivot® for Microsoft® SharePoint®
http://www.microsoft.com/en-us/download/details.aspx?id=35577

Microsoft® SQL Server® 2012 SP2 PowerPivot® for Microsoft SharePoint 2013®
http://www.microsoft.com/en-us/download/details.aspx?id=43342

Microsoft® SQL Server® 2014 PowerPivot for Microsoft SharePoint®
http://www.microsoft.com/en-us/download/details.aspx?id=42300 

Comments (8)

  1. Excellent article. Thank you.

  2. Anonymous says:

    I have had several customers experience the PowerPivot "scheduled data refresh" running over

  3. Anonymous says:

    Recent Releases and Announcements   ·          SQL 2012

  4. Tollie Contento says:

    So glad I found this. Perfect description of steps.

  5. Anonymous says:

      Recent Releases and Announcements   ·        Microsoft Disaster

  6. Richard says:

    I get an error upgrading from 11.0.3000.0 to 11.0.5058.0 on an SSL site. Executed as a farm admin account in local admins group, and PowerPivot Configuration run as administrator. Failure while running action: Upgrade PowerPivot Features in Central Administration.
    Upgrade PowerPivot Admin feature instances failed. Errors during PowerShell script execution. Pipeline Error when running PowerShell script Cannot find an SPWeb ovject with ID or Url :
    https://custweb.mydomain.local and site Url
    https://custweb.mydomain.local. Running PS Script failed. Reason: Error during PowerShell script execution. Exception while executing action UpgradePowerPivotAdminFeatureInstances:Failed running script from different
    app domain. Self signed cert being used in a test environment. Validate button passes all tests.

  7. Anonymous says:

    Over the years, we have had customers engage us for PowerPivot configuration cases, but the issue lies

  8. Pradeep Sharma says:

    Perfect and Thanks Rick Andring for all Help 🙂

Skip to main content