Export (0) Print
Expand All

Export a Power View Report to PowerPoint

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.

You can export an interactive version of your Power View in SharePoint report to PowerPoint 2007, 2010, and 2013. 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.

You can modify the PowerPoint presentation as you would any other, with styles and other enhancements. Note that these do not affect the Power View views—they remain opaque areas on the slide. The font and size of text in the Power View views also remain unchanged.

When you export a Power View report to PowerPoint, each view is a separate Silverlight control on its own slide. You can copy each view and paste it in a different PowerPoint presentation.

These actions are not supported:

  • Pasting multiple views onto the same PowerPoint slide.

  • Manually inserting or modifying the properties of a Silverlight control that loads Power View in PowerPoint.

If you have chosen not to save preview images—the static image of each view in its current state as a preview for other users in PowerPivot Gallery and other applications—with the Power View report, when the PowerPoint presentation opens you will see placeholder images.

Note Note

If the report has no preview images, then in PowerPoint when you go to reading or slide show mode, the Power View view is automatically interactive. You do not need to click click to interact.

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

You can save the PowerPoint file anywhere. As long as it can access the Power View report on the SharePoint server, the Power View views continue to be interactive.

If the PowerPoint file does not have access to the Power View report on a SharePoint server, then you see the same static (or placeholder) images in all PowerPoint modes—normal, slide show, and reading modes—and the Power View views are not interactive.

Say you export a Power View report to PowerPoint. When you update and save the Power View report in Power View, the next time you view the PowerPoint presentation in slide show or reading view mode, you will see the updates to the Power View views.

  1. Save the Power View report, if you haven’t done so yet. If you export a Power View report to PowerPoint with unsaved changes, it will prompt you to save the report first.

  2. On the File menu, click Export to PowerPoint.

  3. Save the new PowerPoint presentation.

    You can save the PowerPoint file anywhere. As long as it can access the Power View report on the SharePoint server, the Power View views continue to be interactive.

  4. After the export is complete, open the saved presentation in PowerPoint.

    PowerPoint opens in normal mode. A static image of each Power View view is centered on a separate slide.

  5. If necessary, in PowerPoint click Enable Editing.

  6. In the lower-right corner, click the Reading View or Slide Show button.

    You can interact with the visualizations in PowerPoint slide show or reading view mode.

  7. In the lower-right corner of the slide, click click to interact to load the live Power View report from the SharePoint server.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft