SharePoint Pals
 | Sign In
Configuration Steps of PowerPivot for SharePoint 2013
by Ahamed Fazil Buhari 2 Jan 2017
SharePoint Developer
Today  :   12     Total  :    409

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.


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


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.


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.


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.


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.


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.


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


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


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


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.


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

Thank you for reading.

Happy Coding


blog comments powered by Disqus

SharePoint Pals

SharePoint Pals, a community portal for SharePoint developers, Administrators and End Users. Let's join hands and share the point together.
Read this on mobile


Angular Js Training In Chennai
Advanced Angular Js training with real world developer scenarios
Angular Js, Web Api and Ionic for .Net Developers
All in one client side application development for .Net developers
Angular Js For SharePoint Developers
Get ready for the future. Its no more just C#

Get Connected

SharePoint Resources

SharePoint 2013 and 2010 Web Parts
Free Web Parts with Source Code for SharePoint Community

SharePoint 2013 Books and Tutorials
Collection of free SharePoint 2013 books and tutorials (eBooks, pdfs)

Supported By

Contribute your article and be eligible for a one month Free Subscription for Plural Sight. The Author of the most popular New Article (published in the previous month) will be awarded with a Free One month Plural Sight Subscription. Article can be sent to in a word document.

Related Resources

Recent Tweets

Twitter January 15, 00:25
How To Enable Target Value And Actual Value In #D3 Gauge Chart

Twitter January 15, 00:24
How To Open #SharePoint List Hyperlink Column In Modal #Popup Window

Twitter January 15, 00:24
Quick Introduction To #Asp.NetCore And It’s Features

Twitter January 15, 00:22
How To Configure #PerformancePoint Services To Use Secure Store In #SharePoint 2013

Twitter January 15, 00:21
How To Block Or Disable #Office365 Services

Follow us @SharePointPals
Note: For Customization and Configuration, CheckOutRecent Tweets Documentation