Configuration of Power Pivot Reports For SharePoint 2013

Introduction

In this article we will learn how to configure Power Pivot for Sharepoint 2013.

Power Pivot

It extends the capabilities of the PivotTable data summarization and cross-tabulation feature with new features such as expanded data capacity, advanced calculations, ability to import data from multiple sources and the ability to publish the workbooks as interactive web applications. As such, Power Pivot falls under Microsoft's Business Intelligence offering, complementing it with its self-service, in-memory capabilities.

As a self-service BI product, Power Pivot is intended to allow users with no specialized BI or analytics training to develop data models and calculations, sharing them either directly or through SharePoint document libraries.

Microsoft Power Pivot for Excel is an add-in that you can use to perform powerful data analysis in Microsoft Excel, bringing self-service business intelligence to your desktop.

Configuration of Power Pivot in SharePoint2013

Open the Central Administration then click on the Manage Service Application and configure the Excel Services.

(Excel Services Reports Displayed in SharePoint 2013)

Click on the Security and Configure managed accounts.

 

Register New Managed Account.

 

Open the Secure Store Service.

 

Click on the New tab.

 

Create New Secure Store Target Application

 

Specify the authentication here.

 

Select the Target Application Admin.

 

Set the Credentials here.

 

Enter the Credential Owner details here.

 

To grant content database access to the managed account, click Start, click All Programs, click Microsoft SharePoint 2013 Products, right-click SharePoint 2013 Management Shell and then click Run as Administrator.

At the Windows PowerShell Command Prompt, type the following syntax (press Enter after each line):

$w = Get-SPWebApplication -identity http://<WebApplication>
$w.GrantAccessToProcessIdentity("<Domain>\<Account>")

Then download and install spPowerPivot.

Download and install spPowerPivot

 

Open the Power Pivot configuration Tool from the start menu.

 

Run the configuration tool.

 

 

Select the "Create PowerPivote Service Application "and uncheck the "Include this action in the Task List".

Then Run

 

Completed successfully.

 

Again open Manage Service Application and click on New and select "SQL Server PowerPivot Service Application".

 

Here we need to enter the application pool details and Configure the user account.

 

Select the Database Authentication.

 

New a PowerPivot Service Application is created.

 

Open Manage Service Application and click on the PowerPivoteService Application.

 

In the configuration setting add the Data refresh Account and enter the other configuration.

 

Now again we need to run the PowerPivot Configuration tool and select the Activate Powerpivot Feature in a Site Collection and select the site URL in the right side. Click on the Validate button, after the validation click on Run.

 

After the completion of this click on Exit.

 

Open the Central Administration then select System Setting => Manage Services on Server.

 

Yes the service is started.

 

Now open the SharePoint Site then seelct Site Setting => Site Collection Admin => Site collection features and Activate the PowerPivot Feature Integration for Site Collection.

 

Reference

Configure Power Pivot for SharePoint 2013

Conclusion

In this article we explored how to configure the Power Pivot in SharePoint 2013.