PowerPivot Configuration for SharePoint 2013

Installing the Power PowerPivot for SharePoint Add-in

This post is continued from here - PowerPivot Installation for SharePoint 2013

1. PowerPivot for SharePoint Add-in (spPowerpivot.msi) - Install the spPowerpivot.msi on all Sharepoint servers in the farm.Copy the install file (\\SQL Server\Enterprise Edition\SQL Server 2012 EE with SP1\PCUSOURCE\1033_ENU_LP\x64\Setup) to all the servers in the farm.Click Next.

2. Click I accept. Click Next.

3. Click Next

4. Click Install.

5. Click Finish

6. These two icons appear after the install of the spPowerPivot.msi

PowerPivot Configuration Tool (only on the servers where POWERPIVOT was installed.)

PowerPivot for SharePoint 2013 Configuration (appears in all servers)

7. Click On Start ->PowerPivot for SharePoint 2013 Configuration. Click OK.

8. Click on all the options on the left to make sure that nothing is left blank.

9. For the secure Store Service master key also use the same passphrase as the farm (that is what I did .Easy to remember J).

Please note that the Target Application ID is PowerPivotUnattended Account [PowerPivotUnattendedAccount and domain\s_sp_sql]

10. Click Validate.

11. Click OK and Run

12. Click Yes.

13. Progress shown

14. Click OK .Don't activate at site collection level. Permission is needed for that. Uncheck that part .Close it and run the whole thing once more and manually uncheck the Activate PowerPivot Feature in a Site Collection and check all others.

15. Click OK and click Exit.

Note : The reason why Activate PowerPivot Feature in a Site Collection fails is that the account [domain\s_sp_sql] is not having the permission on the site collection

16. Browse to Central Administration ->Services on the Server. PowerPivot is started

17. Browse to Central Administration ->Manage Service application. PowerPivot is listed there.

18. Activate the feature at site collection level