Once a PowerView Dashboard is hosted within the PowerPivot Gallery, there is one cool feature that you can take advantage of which allows you to export any of the dashboards to PowerPoint and then have a live and interactive version of the dashboard as a PowerPoint slide.
NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.
HOW TO DO IT
To export PowerView Dashboards to PowerPoint, follow these steps:
- Open up the PowerView dashboard that you created and published to the PowerPivot Gallery and then from the Files menu, select the Export to PowerPoint option.
- When it says that the export is complete, click the Save button.
- Now, give your PowerPoint a name and click the Save button.
HOW IT WORKS
Now when you open up the PowerPoint, you will see a slide that has a copy of the report embedded in it.
When you go into slideshow mode, you will notice a small Interact button in the bottom right of the form.
If you click on the button, the dashboard becomes interactive, receiving all of the data from the PowerPivot Data Source that you hosted on the PowerPivot Gallery.