Export (0) Print
Expand All
3 out of 10 rated this helpful - Rate this topic

Creating, Saving, Exporting, and Printing Power View Reports

SQL Server 2012
Important note Important

Please visit the most up-to-date Power View documentation on office.microsoft.com. Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.

Power View reports are built on data models. Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is tightly integrated with SharePoint Server 2010 so creating, opening, and saving Power View reports all take place in SharePoint Server 2010.

You always start Power View from a data model in a SharePoint Server 2010 document library or in a PowerPivot Gallery. The model can be:

  • A PowerPivot file (XLSX) in a PowerPivot Gallery in SharePoint Server 2010. For more information, see Use PowerPivot Gallery.

  • A shared data source (RSDS) with a Microsoft Business Intelligence Semantic Model data source type, based either on a PowerPivot file, or a tabular model on a Analysis Services server. For more information, see Create a Shared Data Source for a Data Model (SSRS).

  • A BISM connection file (BISM) based on a tabular model on a Analysis Services server. BISM connection files can be either in a standard SharePoint Server 2010 document library or a PowerPivot gallery. For more information, see PowerPivot BI Semantic Model Connection (.bism).

Read more about Data models.

Arrow icon used with Back to Top link Back to Top

To create a Power View report, you launch Power View from a data model file in SharePoint Server 2010. Models can be in a SharePoint Server 2010 document library or in a PowerPivot gallery.

To create a Power View report from a PowerPivot Gallery

  • Click the Create Power View Report icon in the upper-right corner by the PowerPivot (XLSX) file.

To create a Power View report from a SharePoint document library

  • Click the down arrow next to a shared data source (RSDS) or BISM Connection File (BISM), and then click Create Power View Report.

The Power View design environment opens, and you see the view where you build your reports.

Arrow icon used with Back to Top link Back to Top

When you open reports in a PowerPivot gallery, you can choose to open the report at a specific view.

To open a report in a SharePoint Server 2010 document library

  • To open a report in reading mode, click the report title.

  • To open a report in edit mode, click the down arrow next to the report and then click Edit in Power View.

To open a report in a PowerPivot gallery

  1. Click any of the images of the report.

    The report opens at that view in reading mode.

  2. To edit the report, click Edit Report in the upper-left corner.

Arrow icon used with Back to Top link Back to Top

You save a Power View report to the same SharePoint instance as the model from which you launched Power View.

  1. To save the report, on the ssCrescent File menu click Save or Save As.

    The first time you save the report, the default location will be the folder where the model is located.

  2. To save it to a different location, browse to that location, and then click Save.

  3. By default, the Save preview images with report check box is selected. For privacy reasons you may want to clear it and not save preview images.

    For more information, see Choose Whether to Save an Image of Each View with the Report.

Note Note

You may be able to edit a report, but not have the permissions to save to that SharePoint library or folder.

Permissions for Power View

Power View uses SharePoint permissions to control access to Power View reports. If you have adequate permissions for a SharePoint folder, then you can open a Power View report in edit or reading mode. You can modify the report in edit mode as much as you want, but to save your changes you need Add Items permissions for the destination library or folder, or Edit Items permissions to overwrite an existing document.

RDLX file format

Power View creates files with the RDLX file format. These are not compatible with RDL files you create in Report Builder or SQL Server 2012 Reporting Services (SSRS). You cannot open or edit RDL files in Power View, and vice versa.

Arrow icon used with Back to Top link Back to Top

You can export an interactive version of your Power View report to PowerPoint. Each view in Power View becomes a separate PowerPoint slide.

Interacting with Power View reports exported to PowerPoint is similar to interacting with Power View views in Power View reading and full-screen modes. In PowerPoint slide show and reading view modes, you can interact with the visualizations and filters that the report creator has added to each view, but you cannot create visualizations or filters.

For more information, see Export a Power View Report to PowerPoint.

Arrow icon used with Back to Top link Back to Top

You can refresh the data in a Power View report without also refreshing the page.

  • Click the Refresh button on the Power View Quick Access Toolbar.

Note Note

If you click the Refresh button in your browser, and then click Leave this page, you will lose whatever changes you have made to the report since you last saved it.

Arrow icon used with Back to Top link Back to Top

You can print a Power View report from design or reading modes, but not from full-screen mode. Power View prints one view at a time─the current view. The view always prints in landscape orientation, regardless of settings in the Print dialog box. It prints exactly what you see in the view. For example, Power View prints:

  • The part of a visualization that is visible when you print, if the visualization has a scroll bar.

  • The selected tile in a tile container.

  • The Filters Area, if it is expanded.

  • The current frame of a scatter or bubble chart with a play axis.

To print a view

  1. To print a view, on the ssCrescent File menu click Print.

    The browser Print dialog box opens.

  2. Click Print.

Arrow icon used with Back to Top link Back to Top

Data models are the next generation of models designed specifically for analytical and reporting workloads. Data models can import data from a wide variety of data sources including:

  • SQL Server

  • DB2

  • OData

  • Oracle

  • Teradata

  • And others

Data models can be built by end users in Microsoft Excel by installing the PowerPivot for Excel, or by model developers in SQL Server Data Tools (SSDT) in an IT focused organization, and then deployed to a SQL Server 2012 Analysis Services (SSAS) server. They can deploy the model to a document library in SharePoint Server 2010 or to a PowerPivot gallery, a special purpose SharePoint Server 2010 document library that provides rich preview and document management for published Microsoft Excel workbooks that contain data models.

For more information about data models, see Tabular Modeling (SSAS Tabular).

Arrow icon used with Back to Top link Back to Top

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.