O'Reilly logo

Reporting with Microsoft SQL Server 2012 by Bill Anton, James Serra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Setup

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required