Installing Reporting Services for SharePoint 2013 to support Power View

Today I am installing Microsoft SQL Server 2012 Reporting Services (SSRS) to enable the Power View feature in SharePoint 2013.  There are three steps to this process:

• Install, register and start Reporting Services Report Server
• Create a Reporting Services Service Application
• Activate the Power View Site Collection Feature

Step 1 – Install Reporting Services Report Server in SharePoint mode

1. Log on to your SharePoint Application server and run setup.exe on the SQL installation media
2. Click Installation in the navigation pane and then click New SQL Server stand-alone installation or add features to an existing installation
3. On the Setup Support Rules page review any warnings and click OK
4. On the Product Key page enter your key and click Next
5. On the License Terms page accept the lice terms and click Next
6. On the Setup Support Rules page review any warnings and click Next
7. On the Setup Role page choose SQL Server Feature Installation and click Next
8. On the Feature Selection page from the list of available shared features select the Reporting Services – SharePoint, Reporting Services Add-in for SharePoint Products and SQL Server Data Tools.  Click Next
   
9. On the Installation Rules page review any warnings and click Next
10. On the Disk Space Requirements page ensure there is enough space available for the installation and click Next
11. On the Reporting Services Configuration page select Install Only and click Next
    
12. On the Error Reporting page click Next
13. On the Installation Configuration Rules page review any warnings and click Next
14. On the Ready to Install page click Install
15. Click Close when complete and restart the server if required
16. Open a SharePoint Management Shell window
17. Issue the following commands:

Install-SPRSService
Install-SPRSServiceProxy
Get-SPServiceInstance -All | Where {$_.TypeName -Like "SQL Server Reporting*"} | Start-SPServiceInstance

Step 2 – Create a Reporting Services Service Application

1. Log in to Central Administration
2. Under Application Management click Manage Service Applications
3. From the New menu choose SQL Server Reporting Services Service Application
4. Enter a name for the service application and configure the options to suit your environment.  I have chosen to use an existing application pool.  Click OK
   
5. Click OK once the service application is created

Step 3 – Activate the Power View Site Collection Feature

1. Navigate to the required site and open the Site Settings
2. Under Site Collection Administration click Site Collection Features
3. Click Activate next to Power View Integration Features