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:
- Microsoft SQL Server 2012 service pack 1
- Microsoft SQL Server 2012 SP1 Reporting Services Add-in for Microsoft SharePoint
And Silverlight is required at all the machines where you want to access power view reports.
- Microsoft Silverlight
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.
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.
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.
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.
After installation make sure that SQL Server reporting services is running in SharePoint.
To check this go to Central Administration > Services on the server
Also create a service application for SQL Server Reporting Services Service.
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.
Create Power View report
Create a Power Pivot site in SharePoint
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.
It will launch the power view report designer where you can create amazing Power View reports.
In another post I will share about creating a power view reports connecting to SSAS.