Chapter 22

Introduction and Configuration of Power View

What's in this chapter?

  • Learning about Power View architecture
  • Reporting Services SharePoint Integrated Mode — installation and configuration
  • Preparing model connections for the Power View tutorial
  • Understanding data source connection options

In previous chapters, you learned how to create BI semantic models. In this chapter, you see how to install and configure Power View, which is part of SQL Server 2012 Reporting Services in SharePoint Integrated Mode. Power View enables you to interactively explore, visualize, and present data from PowerPivot workbooks and from tabular models hosted on an Analysis Server.

This chapter focuses on setting up Power View and its architecture, and configuring data connectivity for a variety of scenarios. It provides the basis for Chapter 23, which demonstrates how Power View enables business users to interactively explore and visualize data.

Reporting Services Power View

Power View is a feature of SQL Server Reporting Services 2012 in SharePoint Integrated Mode. The deployment consists of the following components that in the most basic scenario, you can install on one machine:

1. SharePoint Server 2010 with Service Pack 1
2. SQL Server 2012 Database Engine (alternatively SQL Server 2008 or 2008 R2 works, too)
3. SQL Server 2012 Reporting Services and Reporting Services Add-In
4. SQL Server 2012 PowerPivot for SharePoint
5. Optional: SQL Server 2012 Analysis Services standalone server instance ...

Get Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.