Installing & Configuring PowerView for SharePoint 2010/2013

After a little bit research on creating PowerView report in SharePoint, I am going to share my experience and list down prerequisites that you must configure with your system before going to create Power View reports.

I had following configuration at server side:

And Silverlight is required at all the machines where you want to access power view reports.

Below is what I did next:

Install SQL server Power Pivot for SharePoint

Run the setup for Microsoft SQL Server 2012 service pack 1. Select SQL Server Power Pivot for SharePoint installation. If you already have a Database Engine then uncheck the option to add database engine to the installation.

SQL Server PowerPivot for SharePoint

Configure Power Pivot for SharePoint

After completing step 1, you will have two configuration tools one is for SharePoint 2010 and other is for SharePoint 2013 to configure Power Pivot for SharePoint.

Go to Start > Programs > Microsoft SQL Server 2012 > Power Pivot Configuration Tool.

Power Pivot Configuration Tool

Start the required configuration tool and validate all the tasks. You might need to add or change some of the input values to pass the validation check. After that run the tool to complete the configuration.

Configure PowerPivot for SharePoint

Install SQL Server reporting service in SharePoint Integrated mode

Run the setup for Microsoft SQL Server 2012 service pack 1. Select the Reporting Services for SharePoint feature for installation.

Reporting Services - SharePoint

After installation make sure that SQL Server reporting services is running in SharePoint.

To check this go to Central Administration > Services on the server

SQL Server Reporting Services Service

Also create a service application for SQL Server Reporting Services Service.

SQL Server Reporting Services Service Application

You need to associate this service to the web applications where you need PowerView Reports.

Install Microsoft SQL Server 2012 SP1 Reporting Services Add-in for Microsoft SharePoint

Download the setup and complete the installation. This will enable you to create and view Power View Reports in SharePoint. To cross check the installations, see the Power View Integration feature is active in site collection features.

Power View Integration feature

Create Power View report

Create a Power Pivot site in SharePoint

PowerPivot Site

Power Pivot site has a pre-built Power Pivot gallery where you can store Power Pivot workbooks and reports. Upload a Power Pivot workbook to the gallery. To create a Power View report from that workbook click on the Power View button as shown in the image below.

Create Power View Report

It will launch the power view report designer where you can create amazing Power View reports.

Power View Report Designer

In another post I will share about creating a power view reports connecting to SSAS.

Leave a Reply

Close Menu