Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

Power View within SharePoint


This section describes using Power View within SharePoint. It can be used with the enterprise editions of SharePoint 2010 or SharePoint 2013.

Setup

Although Power View is very easy to use, setting up the required infrastructure when using it with SharePoint can be a bit tricky. Power View is automatically installed when you run the SQL Server 2012 setup and choose Reporting Services Add-in for SharePoint Products on the Feature Selection page. This is a newer version of the add-in, which includes Power View, compared to the version that is installed with SharePoint 2010 that does not include Power View. The following are the software requirements for Power View:

  • SQL Server 2012 database engine (Business Intelligence Edition or Enterprise Edition).

  • SQL Server 2012 Reporting Services (in SharePoint Integrated mode).

  • SQL Server 2012 PowerPivot for SharePoint.

  • SQL Server 2012 Analysis Services (SSAS) in tabular mode if using a tabular model connection.

  • SQL Server 2012 Analysis...