Saving PowerPivot Data Models to the PowerPivot Gallery

Once you have created your PowerPivot Gallery, you can publish the PowerPivots that you create within Excel there and host them within SharePoint.

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 publish a PowerPivot Workbook to a PowerPivot Gallery, follow these steps:

1. From the Save As menu item, select the SharePoint option and in the navigation bar, paste in the URL for your new PowerPivot Gallery. Give your Workbook a name and then click the Save button.
   

HOW IT WORKS

When you return to the PowerPivot Gallery you will see a thumbnail view of the workbook.