Configure PowerPivot for SharePoint 2013 – Part 3


Part 3 of this Post is about Testing PowerPivot and Power View. PowerPivot is an Excel Add-on that allows us to create reports in Excel where we can use Slicers and later publish the excel sheet in SharePoint to view it in browser.

Let’s create a Business Intelligence Site collection to test Power Pivot.

Go to Central Administration à Create Site Collection

Provide Title, Url, Select Template as Business Intelligence and primary administrator and click OK.

Click on the site collection link to open.

Let’s see PowerPivot in Action

Click on Site Contents à Documents à Click on Excel Services Sample Workbook

Let’s change the Item to Charcoal from left top slicer of the sheet.

Now let’s click on 2011

Now Let’s Enable Power View

PV is a Site Collection feature that is provided by SQL Server Reporting Services to allow Rich and Powerful reports.

Click on Site Link using left top Global Navigation à Click on Site Settings Icon and Site Settings

Under Site Collection Administration Click on à Site Collection Features

Make sure Power View Integration Feature is activated.

Let’s Create a New Library to store our Reporting Services Reports

Click Site Contents à Add an App and Select document library and choose Document library. Select Advance Options. Set Name as “Reports” and Template to None and click Create.

Go to Library Settings à Advanced Settings à Set Yes for Allow Managed of Content Types and Click OK.

Click Add from Existing Content Types à Change Group to SQL Reporting Services à Add all the content types and click OK.

End of Part 3.  In the next post I will show you how to create a basic report using SQL Reporting services and Power View.

Configure PowerPivot for SharePoint 2013 – Part 2


Installation of PowerPivot is 2 step process. First we have to enable PowerPivot mode in SQL Server 2012. We need to setup a new database instance with PowerPivot. It will also enable Analysis services as SharePoint Integrate Mode.

Step 2 – Configuring PowerPivot Add-On

First we have to download the add-on. You can download from here.

Double Click to start installation.


Click next


Accept the agreement click next


If you have more than 1 server make sure you install SQL Server 2012 Feature Pack “ADOMD.NET” to all the servers in the farm.


Click Install


Click Finish.


Configure PowerPivot using PowerPivot Configuration

Press Start and type PowerPivot

Click on PowerPivot for SharePoint 2013 Configuration.


Click OK


Wait for validation to complete.


Confirm the PowerPivot SQL Instance Name

To confirm the Database server. Open SQL Server Management Studio and click on Server name dropdown and “Browse for more”


Expand Database Engine Click on PowerPivot SQL Instance and click OK. Now Copy the server name. Click Connect to confirm that you are able to login.



Enter the password for Default Account

Paste the Instance Name

Enter passphrase for future addition to PowerPivot Farm.

Enter PowerPivot


Make sure there are no errors then Click Run then Yes.




Click Exit on PP Configuration Tool.

Open Central Administrator Manage Service Application

You will find PowerPivot, Excel Services and Secure Store Service application which I never had.


End of Part 2.

Configure PowerPivot for SharePoint 2013 – Part 1


Installation of PowerPivot is 2 step process. First we have to enable PowerPivot mode in SQL Server 2012. We need to setup a new database instance with PowerPivot. It will also enable Analysis services as SharePoint Integrate Mode.

Step 1 – Install PowerPivot in SQL Server 2012

Click New SQL server standalone or add features

Click OK

Wait to download the updates or Uncheck the checkbox to continue

Click Next

Click OK if you don’t have any issue

Click Perform a new Installation of SQL Server 2012

Provide Key

Accept : Next

Select SQL Server PowerPivot for SharePoint

Click Next

Click Next

Change Instance ID if you want or click Next

Click Next

Provide SQL Analysis Service Account and password

Click Add Current User and click Next.

I choose Mixed Mode for my installation and it is not required.

Click Add Current User to add it as administrator in SQL Analysis services.

Next

Click Next

Review the installation and click Install.

Give it couple of minutes.


End of Part 1.