Configuration Steps of PowerPivot for SharePoint 2013

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

Alright, this is the continuation of my previous article “How to add SQL Server 2012 PowerPivot to the Excel Services in SharePoint 2013” and in this article we will go ahead and see the step by step approach to run the PowerPivot for SharePoint 2013 Configuration Wizard and also I’ll explain how to resolve the configuration errors. Let’s go ahead

Please follow the below steps to run the PowerPivot for SharePoint configuration wizard.

Step 1: Open up the PowerPivot for SharePoint 2013 Configuration application, you also notice same identical icon for PowerPivot Configuration Tool, but we do not want that.

image

 

 

Step 2: Configuration wizard will pop up and it has the option “Configure or Repair PowerPivot for SharePoint”. This the only option we have right now because we haven’t run this already. Click OK

image

Step 3: Now the new window will open and it will be having too many levels to validate. The green flags and warning signs. We need to concern on the warning signs, because we need to change them to green flag too. Once everything is fine, we will go ahead and validate all and then we will run the wizard.

image

Step 4: Go to the top level and provide the following values,

a) Default Account Username (I’ve provided Install account, you can change it if u want to)

b) Default Account Password

c) Database Server (we installed PowerPivot on our SharePoint Server, but sill we need to point to our SQL Server – Because although the PowerPivot instance is on our SharePoint Server, we want PowerPivot for SharePoint to build the database on our SQL Server).

d) Passphrase – Add it, so that we can add other servers to our farm later.

Once we done this, you notice that there won’t be any warning sign. Now we could validate, but we need to validate every single time when we change one of these. So we are going to validate at the end.

image

Step 5: Go to Create PowerPivot Service Application, we don’t have to create the PowerPivot Service application by going to SharePoint Central Administration, because this wizard is going to do it for us. But we have the parameters like Service name, Database Server and Database name that we can change.

image

Step 6: In Deploy Web Application Solution, here we’re going to go ahead and tell it which web application we want PowerPivot to work with.

You may want this to work on all of the web application. At that time, all we can do is assign it to one and you can use Central Administration to select an application from a list, like it says in the above context.

image

Step 7: Now we want to activate PowerPivot Feature in a site collection. So, click on Activate PowerPivot Feature in a Site Collection in left navigate and choose the site collection.

image

Step 8: Go to Create Unattended Account for DataRefresh because there’s nothing to do with above titles. Here, you can edit

a) Target Application ID

b) Friendly Name for Target Application

c) Unattended Account User Name (Here I’m not using install account, instead I gave another account – remember you can give any account according to your organization procedures and policies)

d) Unattended Account Password

e) Site URL (which we want this to work for)

After everything is done, it’s time to go ahead and click on Validate

image

 

 

Step 9: Once the validations are successful, click on Run and click on Yes for the below warning message.

image

It will take 15 steps to complete the process and it takes few minutes.

image

After successful configuration, you can find PowerPivot Service application in your Central Admin.

Error Handling

If you find an error during Configuration Run like below image, then go ahead and open up your SQL Server Management Studio -> go to content database of the selected web application -> under Security add User account which you used in Step 4 and provide SPDataAccess role membership.

image

And then come back to PowerPivot Configuration Wizard, click on Validate and Run.

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