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:

• Microsoft SQL Server 2012 service pack 1
  http://www.microsoft.com/en-us/download/details.aspx?id=35575
• Microsoft SQL Server 2012 SP1 Reporting Services Add-in for Microsoft SharePoint
  http://www.microsoft.com/en-us/download/confirmation.aspx?id=35583

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

• Microsoft Silverlight
  http://www.microsoft.com/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.

Configure PowerView(Reporting Services feature)on existing SharePoint 2013 farm with BI Features

Configure Power View (Reporting Services features) on existing SharePoint 2013 Farm with BI features.

Configuration Summary

• Install SQL Server 2012 SP1 CTP3
• Uninstall Report Services - Native If you have installed it
• Install Reporting Services – SharePoint & Reporting Services Add-In for SharePoint Product
• Install Analysis Services In Tabular Mode and Data Tools
• Install SharePoint Reporting Service
• Install and Configure Power Pivot for SharePoint
• Configure Performance Point Services
• Configure Reporting Services
• Check SharePoint Power Pivot Integration

Install SQL Server 2012 SP1 CTP3

First you need need at least SQL Server 2012 SP1 CTP 3 installed in your farm.  If not you can download and install it from here
Better if you can restart the machine after installation.

Uninstall Report Services – Native

If You have already installed Reporting services Native go to Control Panel and Uninstall SQL Server and remove the Reporting Services – Native Feature.

Install Reporting Services – SharePoint & Reporting Services Add-In for SharePoint Product

If you are not installed Reporting Services – SharePoint and Reporting services Add –ins
you need to run SQL Server 2012 and select Add features to an existing instance of SQL Server 2012
 
Select Reporting Services – SharePoint and Reporting services Add –ins for SharePoint Products and Proceed
 
Then install as Reporting Services SharePoint Integrated Mode

Install Analysis Services In Tabular Mode and Data Tools

If you have already installed the Analysis services uninstall in and install it in Tabular Mode.


after the installation restart the machine . (This is not mandatory)

Install SharePoint Reporting Service

Open the SharePoint Management Shell and run following commands If every thing is fine it will return no errors.

• Install-SPRSService
• Install-SPRSServiceProxy

Note: If you come across this error you need to install SQL Server 2012 SP1 CTP3 again and restart the machine again.

Install-SPRSService : The term 'Install-SPRSService' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the

Install and Configure Power Pivot for SharePoint

Download PoverPivot for SharePoint.  (http://www.microsoft.com/en-us/download/confirmation.aspx?id=35577)
Run the setup as administrator.


After the installation you need to run the PowerPivot Configuration as a admin.
 


Validate and run the configuration.

Configure Performance Point Services
Go to Central Admin and go to Manage service applications and create Performance Point Service Application.

When creating the Service Application make sure you inserted the Unattended Service Account.

ultimately check PerformancePoint Service is up and running.

Configure Reporting Services

Go to Central Admin and go to Manage service applications and create Reporting Service Application.

When you are creating make relevant web associations to  your web applications.

When service application created navigate to Provision Subscriptions and Alerts

and enter spadmin account and make in as Windows Credentials. (This account should have sysadminpermission in the Database )

Then make sure SQL server Agent is up and running

Then download the Script and execute the SQL.



and finally make sure SQL Server Reporting Services is running.

Now You are almost over.
Now you need to go to site collection and activate features
Site Collection Features
Performance Point Site Collection Feature

PowerPivot Feature Integration for Site Collections

Site Features
PerformancePoint Site Feature
SharePoint Server Enterprise site feature

SharePoint 2013 site stuck in read only mode

 SharePoint 2013 sites in read-only mode. When I browsed the site I got the following message: “We apologize for any inconvenience, but we’ve made the site read only while we’re making some improvements.”

On further investigation I noticed that the nightly backup of this specific site collection did not complete successfully”. When you backup a Site, SharePoint places the site in read-only mode. But since my backup hanged the site never got out the read-only mode.
When you check the site in the Site Collection Quota and Locks Screen you’ll find all options greyed out:

Luckily since the April 2013 CU update for SharePoint 2013 we now have the SpsiteAdministration.ClearMaintenanceMode method. So we can clear the flag with the flowing two lines:

$site = new-object Microsoft.SharePoint.Administration.SPSiteAdministration(‘http://intranet.demo.local’)
$site.ClearMaintenanceMode()

and your site is out of maintance mode again!