PowerPivot Gallery Thumbnail Debugging Procedure

I’ve had the odd occasion where the SharePoint PowerPivot thumbnails (in the gallery view) haven’t shown up properly for me, and a while ago I compiled a collection of debugging procedures. I figured I’d share this collection with the world. Some of these were meant more for SP2010, and SQL 2008 / R2, but many of them should still apply to SQL 2012 and SP2013. I don’t promise complete and satisfactory results, just that here’s a large collection of the procedures altogether in one place.




is the basis of the file name of the generated thumbnails;


is the maximum number of snapshots to be taken;


is the maximum amount of time in seconds before the process is aborted.


C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin>GetSnapshot.exe “http://myserver” “http://myserver/PowerPivot Gallery/myWorkbook.xlsx” “C:\Users\marianotn\Desktop” marianotn_test 26 300

From <http://blogs.msdn.com/b/mtn/archive/2010/10/15/how-to-manually-refresh-powerpivot-gallery-thumbnails.aspx>

  • See if you can force a refresh of a thumbnail in the gallery.

    Refresh a thumbnail image

    Use the following steps to regenerate a thumbnail image for a document in PowerPivot Gallery.

    • Switch PowerPivot Gallery to All Documents view. To do this, click Library in the ribbon and change the Current View to All Documents.
    • Select the workbook or report for which you want to refresh the thumbnail image.
    • Click the down arrow to the right, and then select Edit Properties.
    • Click Save. Saving the document forces the snapshot service to regenerate the preview image.

    From <http://technet.microsoft.com/en-us/library/ee637435.aspx>

  • If you’re getting the “Red X”, try the steps below.

    1. Ensure Excel services is rendering workbooks.

    2. Internet Explorer 9 is not installed. Revert to IE8. — IF on IE9 and cannot revert, see below to work-around this.

    Also be sure IE7 is not installed on the server – if so, upgrade to IE8.

    3. Ensure SQL 2008 R2 SP1 for PowerPivot for SharePoint is installed.

    4. Test to see that getsnapshot.exe is being spawned (by checking task manager)

    5. Try running GetSnapshot.exe manually.

    6. Ensure the workbook contains embedded PowerPivot data

    7. Ensure the workbook does not contain more than one data source.

    8. Ensure the file is an .xlsx file.

    9. Verify Alternate Access Mappings are setup correctly.

    10. Add the PowerPivot site to the trusted intranet sites, and ensure you do this for the account running Getsnapshot.exe (most likely your content access account).

    11. Determine if you have the check box checked off for “refresh on open” in the workbook connection properties (this likely has nothing to do with it, but you can try disabling this and see if it makes any difference)

    From <http://social.technet.microsoft.com/forums/en-US/sharepointadminprevious/thread/f339f4ac-2fe6-4709-9b41-1a1d8b7c42ba/#f339f4ac-2fe6-4709-9b41-1a1d8b7c42ba>

  • If your server is on IE9, follow these steps:
  • Verify your default open behaviour for documents in your site collection and at the library level.

    Snapshot will not work if you have chosen to open the workbooks in the Client application. Please refer to the below document on how to turn these features off:

    Configure the default open behavior for browser-enabled documents (Office Web Apps)


    To set the default open behavior for site collections

    • In the SharePoint site collection, click Site Actions, and then click Site Settings.
    • On the Site Settings page, under Site Collection Administration, click Site Collection Features.
    • On the Features page, for the Open Documents in Client Applications by Default feature, click Activate (OpenInClient Feature is enabled) to open documents in the client application. Click
      Deactivate (OpenInClient Feature is disabled) to open documents in the browser.

    To set the default open behavior for a document library by using the document library settings page

    • On the <document library>: All Documents page, under Library Tools, click Library.
    • In the library toolbar, click Library Settings.
    • On the Document Library Settings page, click Advanced Settings.
    • On the Advanced Settings page, in Opening Document in the Browser, select one of the following options:
      Open in the client application When a user clicks on a document in this library, the document will open in the corresponding client application (if available).

    • Open in the browser When a user clicks on a document in this library, the document will open in the Web browser Web app for that document type. When the document is opened in the Web app, the user can then decide to open the document in the client application
    • Use the server default When a user clicks on a document in this library, the document will open by using the default open behavior specified for the server on which SharePoint 2010 Products is installed.

    From <http://social.technet.microsoft.com/wiki/contents/articles/7396.sharepoint-2010-powerpivot-gallery-thumbnailssnapshots-not-rendering-red-x-hourglass-and-lock-en-us.aspx>

  • Make sure you disable the loopback check on EACH SharePoint server in the farm

    Click Start, click Run, type regedit, and then click OK.

  • Ensure that Secondary Login is enabled on each server in the farm.

    Recently I ran into an interesting customer situations with Gallery snapshots not being taken – just an hourglass is showing (meaning that the snapshot generation process is on-going, i.e. the GetSnapshot.exe process is running).

    The problem is visible in the ULS log with this error:

    w3wp.exe (0×1508) 0×0CF4 SSAS Mid-Tier Service Report Gallery 99 High EXCEPTION: System.Exception: CreateProcessAsUser failed with 1058 at Microsoft.AnalysisServices.SharePoint.Integration.SnapshotExtraction.InternalSnapshotExtraction(SnapshotExecutionContext context, Int32& snapshotToolExecutionMask) at Microsoft.AnalysisServices.SharePoint.Integration.SnapshotExtraction.ExtractSnapshots(SnapshotExecutionContext context) at Microsoft.AnalysisServices.SharePoint.Integration.SnapshotHandler.CaptureSnapshot(ListItemInfo itemInfo, WorkbookConnections connections)

    The error 1058 can have as a root cause the fact the Windows service “Secondary Logon” is disabled.

    The service as to be at least in manual (the service will be started by the call to CreateProcessWithToken if the permissions permit it).

    Note: To totally solve the issue, the server needs to be restarted and the properties on the documents to be changed in order to generate a new snapshot.

    From <http://powerpivotgeek.com/2010/10/24/snapshots-not-being-taken/>

  • Look at your Company’s Group Policy: (lots of details of what they did in the link below)

    This problem was solved. Our company’s group policy was the issue.

    The fix*:

    1) add a trust of the URL of the SharePoint site to the group policy

    2) add a trust of the URL of the SharePoint site plus “:”+port number to the group policy

    3) then run gpupdate /force on the back end server after ten minutes.

    4) Make a change to each PowerPivot workbook in a gallery.

    *A new error came up when we click on any slicers from any PowerPivot (using various external data sources) we get this Excel error: “An error occurred during an attempt to establish aconnection to the external data source. The following connections failed to refresh:

    PowerPivot Data.”

    The new error was fixed once we rebooted both servers.

    From <http://social.technet.microsoft.com/forums/en-US/sharepointadminprevious/thread/f339f4ac-2fe6-4709-9b41-1a1d8b7c42ba/#f339f4ac-2fe6-4709-9b41-1a1d8b7c42ba>

  • Other resources:

2 responses to “PowerPivot Gallery Thumbnail Debugging Procedure

    1. It may be called gallerysnapshot.exe which is what it is in SharePoint 2013, so I’m assuming it will be the same for SharePoint 2016.

Comments are closed.