Publishing Your BI Tools to SharePoint - Microsoft Business Intelligence Tools for Excel Analysts - page 295

Figure 15-4: A workbook as shown in Excel Services.

Publishing to a Power Pivot Gallery
A Power Pivot Gallery is a type of document library that showcases Power Pivot reports and allows for
scheduled refresh cycles.

For your end users, the Power Pivot Gallery provides an attractive portal that serves as a one-stop
shop for all the reports and dashboards you publish. For you, the Power Pivot Gallery enables better
management of your Power Pivot solutions by allowing you to schedule nightly refreshes of the data
in them.

You need to speak with your SharePoint administrator about your organization's SharePoint instance
and ask him to consider adding a Power Pivot Gallery to your site. When you have access to a Power
Pivot Gallery, you can upload your Power Pivot workbooks using the same steps you took to publish
a standard workbook to SharePoint.

Figure 15-5 shows a typical Power Pivot Gallery. Note that each workbook is shown as a thumb-
nail, providing users with a snapshot of the each report. Clicking a thumbnail opens the report as
a Web page.

If you're using an Office 365 SharePoint subscription, you unfortunately have no option
for a Power Pivot Gallery, as Office 365 doesn't support it. This may change in the future
as Microsoft continues to add improvements to Office 365.

Note