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.


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.


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

1 comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: