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 Excel 2013

This section describes using Power View within Excel 2013, which requires the ProPlus Edition of Office 2013. Note that Power View is not supported within Excel 2010 or earlier versions.


Power View is an add-on in Excel 2013 that you can enable by following these steps:

  1. In Excel, navigate to FILE | Options | Add-Ins.

  2. In the Manage box, click on the drop-down arrow and select COM Add-ins. Now, click on Go.

  3. Check the Power View checkbox and click on OK.

If the Power View add-on has not been enabled, it will be grayed out on the Excel Insert menu.

Data models

Excel 2013 (ProPlus Edition) now has native support for data models. A data model is a brand new approach to integrating data from multiple tables, in essence, building a relational data source right inside an Excel workbook. The data models are used transparently to provide the tabular data used in a Power View report.

When importing relational data, a data model will be created implicitly when you select multiple...