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:
Get Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.