PowerPivot has a very cool feature that allows you to publish your data to PowerPivot Galleries within SharePoint. This allows users to access and report off the data that you build within Excel, but do it all through the Web. In order to enable this feature, you first need to create a PowerPivot Gallery in 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 create a PowerPivot Gallery site within your existing SharePoint site, follow these steps:
- Open up SharePoint Central Administration and select the Create Site Collection option. When the site creation form is displayed, give your new site a Name and Description, a name for the subsite in the URL field, and select the PowerPivot template option. Then click OK to create the new site.
HOW IT WORKS
When the new site is created, there will be a link in the navigation bar for the PowerPivot Gallery.
The PowerPivot Gallery is now ready to host your PowerPivot data sources.