Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop.
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.
Note: There are two versions of Power View: Power View in Excel 2013 and Power View in SharePoint 2013. You can only export to PowerPoint from Power View in SharePoint 2013.
-
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.
-
In Power View edit mode or reading mode, on the File menu > Export to PowerPoint.
-
Save the new PowerPoint presentation.
Save the PowerPoint file anywhere. As long as it can access the Power View report on the SharePoint server, the Power View views are interactive.
-
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.
-
In the lower-right corner, click Reading View or Slide Show.
You can only interact Power View visualizations in PowerPoint slide show or reading view mode.
-
In the lower-right corner of the slide, click click to interact to load the live Power View report from the SharePoint server.
More in this article
Interacting with Power View views in PowerPoint
Interacting with Power View views 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.
Modifying the PowerPoint presentation
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 aren‘t 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.
Preview images
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 Power Pivot Gallery and other applications—with the Power View report, when the PowerPoint presentation opens you will see placeholder images.
More about choosing whether to save images of views in Power View in SharePoint.
Network access
You can save the PowerPoint file anywhere. As long as the computer running PowerPoint is connected to the same network or domain as the server running Power View, 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.
Updating Power View report
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.
Note that your slides can be enhanced before exporting your reports by changing the slide template or after exporting by using themes, images, and drawing tools.
Permissions for exporting to PowerPoint
Power View uses SharePoint permissions to control access to Power View reports. You can export a report to PowerPoint if you have Open Items permissions. However, you can’t export a report to PowerPoint with unsaved changes. So if you have only Open Items permissions, you can export a report as is, but not modify it and then export it. To do that, you need to save your changes first, meaning you need Add Items or Edit Items permissions.
More about Power View
Power View in SharePoint Server: Create, save, and print reports
