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

Ahamed Fazil Buhari
 
Senior Developer
January 2, 2017
 
Rate this article
 
Views
2527

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

Category : SharePoint

Author Info

Ahamed Fazil Buhari
 
Senior Developer
 
Rate this article
 
Ahamed is a Senior Developer and he has very good experience in the field of Microsoft Technologies, especially SharePoint, Azure, M365, SPFx, .NET and client side scripting - JavaScript, TypeScript, ...read more
 

Leave a comment