Using Power View in Excel 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 126

detach the report from the workbook and share it with others separately. However, you can upload
the workbook to SharePoint (on-premises or Microsoft Office 365) where others can view it online or
download it to their own computer for editing, if they have the appropriate permissions, of course. If
the workbook is less than 5 MB, you can save it to a SkyDrive folder for others to download. SkyDrive
does not support online viewing of Power View sheets in a workbook.

By contrast, you use Power View in SharePoint to create a file with a .rdlx extension that you
can store in a SharePoint document library. This file is a stand-alone report that can be viewed and
edited only online. After opening a Power View in SharePoint report, you can export it to Microsoft
PowerPivot to create an interactive set of slides for data exploration during a presentation, which is a
feature not supported in Power View in Excel.

Another difference between the two editions is the source of the data to visualize. Power View in
SharePoint requires you to access an existing model, whether that model is stored in a PowerPivot for
SharePoint workbook or in a tabular instance of Analysis Services. Furthermore, all views in a Power
View in SharePoint report must use the same data source, whereas each Power View sheet in an Excel
workbook can use a different Data Model in Excel as a source. In fact, Power View in Excel can use a
simple Excel Data Model (described in Chapter 4, “Using PowerPivot in Excel 2013”) as one of its data
sources, which is not a supported source for Power View in SharePoint.

If you want to share Power View in Excel views with others who do not have access to Excel, you
can save the workbook as a PDF document. You don't have this option with Power View in SharePoint,
although that version does give you the ability to export the views as a set of Microsoft PowerPoint
slides. As an added feature, the export retains the connection to the data model and makes it possible
to interact fully with the Power View visualizations as long as the user's computer can connect to the
SharePoint server that is hosting the source reports.

What's new in Power View

Regardless of whether you use Power View in Excel or Power View in SharePoint, there are a variety of
enhancements in the latest edition. There are more visualizations to choose from, additional options
for formatting your reports, support for key performance indicators, and a better exploration experi-
ence through drilling into details.

More visualizations
Power View includes the following two new types of visualizations that you can use to develop new
insights about your data:

Pie Chart A pie chart is useful for comparing a limited number of categories. Power View now
includes a pie chart visualization. Like other visualizations, it supports the highlighting feature

■