How to add SQL Server 2012 PowerPivot to the Excel Services in SharePoint 2013


Ahamed Fazil Buhari
SharePoint Developer
Published On :   02 Jan 2017
Visit Count
Today :  2    Total :   1034
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

Sharegate: Kick-Ass Tool
Think Your SharePoint & Office 365 Are Secure ? Find Out Now!


In my previous articles I’ve explained on topics like “Installation of SQL Server 2012 PowerPivot for SharePoint 2013” and “Steps to Configure Excel Services - SharePoint 2013”. Now it’s time to go ahead and add PowerPivot to our Excel Services.

Please follow the below steps to add PowerPivot to Excel Services.

Step 1: Go to Central Administration and click on Manage service applications.

image

Step 2: Choose the Excel Services service application which we created already.

image

Step 3: In Manage Excel Services Application page click on Data Model Settings.

image

Step 4: In Data Model Settings – We can register instances of SQL Server Analysis services servers. Remember, PowerPivot is a mode of SQL Server Analysis Services. That’s why we are going to add our PowerPivot here and we installed our PowerPivot in SharePoint Server.

image

Step 5: In Add Server page, provide the server name where PowerPivot was installed and its instance (Instance is POWERPIVOT – In “Installation of SQL Server 2012 PowerPivot for SharePoint 2013” article, Step 12 you can find the Instance name). For example: server name should be “SPServer1\POWERPIVOT”

image

Step 6: There it is, PowerPivot successfully added into Excel Services.

image

Next we need to run the PowerPivot for SharePoint Configuration Wizard. I will explain this in my upcoming article.

Thank you for reading.

Happy Coding

Ahamed

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

SharePoint Analytics