I have several excel documents containing PowerPivot tables. They all connect to a SSAS Tabular service (on SQL 2012) via a .odc connection file, all of which is hosted on SharePoint 2013, using the PowerPivot Gallery as the default view. It is imperative that the documents refresh when they are openened, because the data is filtered depending on the user that views the data. However, when I enable the 'refresh on open' feature for the data connection, the gallery refuses to show any thumbnails. When I uncheck this feature the thumbnails show as expected. I'm guessing this might have something to do with time-out.

The workbooks in the screenshots are copies of each other, except that the first refreshes on open, and the other doesn't. PowerPivot Gallery doens't show thumbnails

PS: if I run GallerySnapshot.exe tool by hand, snapshots are generated without errors for all the workbooks.

1 Answer 1


When using the PowerPivot Gallery, thumbnails only appear when the workbook uses embedded data or when an external PowerPivot workbook is used as a datasource. MSDN does not state any support for thumbnails of workbooks based on Tabular Model: http://msdn.microsoft.com/en-us/library/ee637435.aspx#prereq

When using auto-refresh, you basically declare that you always need a data source. Without it, the workbook can rely on its data it already has.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.