Troubleshooting the PowerPivot Gallery. Thumbnails Not Rendering. Invoking and Analyzing the Getsnapshot.exe/Gallerysnapshot.exe

Before you do anything, browse (while logged on the WFE as the account running the Web Application) to C:\Users\<WebAppAccount>\AppData\Local\Temp.  This location MUST exist, I have seen issues where the User Profile for the WebAppAccount does not exist.  This is where the .pngs (thumbanails) are placed prior to being updated in the PowerPivot Gallery.  If they can't be placed here, you can rest assured they will not be updated in the PowerPivot Gallery.



If my blog does not resolve it.  You will need to manually invoke the Getsnapshot.exe, rename the “” file that is generated on the desktop to “thumbnails.txt” and look at its contents.  To manually invoke the thumbnails, find the account that is running your Web Application.  Log into the WFE as that account:


SharePoint 2010:


Start > Run > CMD > C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin


Pass this parameter: GetSnapshot.exe "http://tschauer2010" "http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" "C:\Users\tschauer\Desktop" thumbnail
26 300


SharePoint 2013:


Start > Run > CMD > C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\bin


Pass this parameter: GallerySnapshot.exe "http://tschauer2010" "http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" "C:\Users\tschauer\Desktop" thumbnail
26 300


*To build the above:


  1. You need to know the Web App, in this case: http://tschauer2010 (CA > Application Management > Web Applications > Manage Web Applications > URL): http://tschauer2010
  2. The path of the workbook, in this case: http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx


Here is an example of what it will look like (SharePoint 2010):


 If this runs, you will see the below icons on the desktop (this takes time):


The “thumbnails.txt” (after you rename and open in notepad) could say many things.  Here are examples and how I fixed them.

1. To fix the below, disableloopbackcheck (see KB 896891):

 <SnapshotCaptureLog serverUrl="http://tschauer2010" workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx"
snapshotCount="26" timeout="300">
<Error timeout="True">System.TimeoutException: The operation has timed out.</Error>

Update (1/5/2015):

We ran into another scenario recently where this timeout error was presenting. It turns out that if your site is set up for Forms Based Authentication and you have a login page, snapshots will NEVER be generated properly. The thumbnail rendering for Excel worksheets has issues with non-Windows authentication methods. When a user saves a workbook in a PowerPivot Gallery, SharePoint triggers an event, which PowerPivot Gallery intercepts to launch a Capture Snapshot process that generates a new thumbnail for every worksheet in the workbook. This unattended Capture Snapshot process must authenticate to access the workbook but is generally unable to deal with login pages, such as to enter user credentials in an ASP.NET sign-in form or to select a particular authentication method if multiple methods are enabled on the Web app.

      Source (Page 13):

2. To fix the below add the below Service Pack to the PPIV machine:

Microsoft® SQL Server® 2008 R2 Service Pack 1

<SnapshotCaptureLog serverUrl="http://tschauer2010” workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" fileNameBase="thumbnails"
snapshotCount="26" timeout="300">
<Error>onXLFrameLoad::Error! document.readyState = interactive</Error>
<Error>onXLFrameLoad::Error! document.readyState =

3. To fix the below, you can do one 1 of 2 things found in this KB:

Error message when you try to access a server locally by using its FQDN or its CNAME alias after you install Windows Server 2003 Service Pack 1: "Access denied" or "No network provider accepted the given network path"

Method 1 (recommended): Create the Local Security Authority host names that can be referenced in an NTLM authentication request

1.   Go to REGEDIT > HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > Lsa>MSV1_0
2.   Right click MSV1_0 > New > Multi-String Value
3.   Type ‘BackConnectionHostNames’
4.   Right click & select ‘Modify’
5.   Enter the Hostname of the site: WEBSITENAME (and on a new line enter the FQDN, as well)


Method 2: Disable the authentication loopback check (On all WFE's (make sure to reboot)).

Re-enable the behavior that exists in Windows Server 2003 by setting the DisableLoopbackCheck registry entry in the
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa registry
subkey to 1. To set the DisableLoopbackCheck registry entry to 1, follow these steps on the client computer:

1.Click Start, click Run, type regedit, and then click OK.
2.Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3.Right-click Lsa, point to New, and then click DWORD Value.
4.Type DisableLoopbackCheck, and then press ENTER.
5.Right-click DisableLoopbackCheck, and then click Modify.
6.In the Value data box, type 1, and then click OK.
7.Exit Registry Editor.
8.Restart the computer.

<SnapshotCaptureLog serverUrl="http://tschauer" workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" fileNameBase="thumbnail" snapshotCount="26" timeout="300">
<Error>Terminatingcapture process: 'Illegal redirection to resources outside of the web application:'res://ieframe.dll/navcancl.htm''</Error>
<Error>Terminating capture process: 'Illegal redirection to resources outside of the web application: 'res://ieframe.dll/navcancl.htm''</Error>
<Error>Terminating capture process: 'Illegal redirection to resources outside of the web application: 'res://ieframe.dll/navcancl.htm''</Error>
<Error>Terminating capture process: 'Illegal redirection to resources outside of the web application: 'res://ieframe.dll/navcancl.htm''</Error>

If you are using SSL you will want to look at you CAPI2 Event logs (Application and Services Logs > Microsoft > Windows > CAPI2) for GallerySnapshot.exe errors.  I have seen where servers are unable to retrieve the SSL cert for a couple of reasons (expiration or firewall/proxy blocking).  A workaround is to log on to the Web Front Servers as the account running the Web Application > Internet Options > Advanced > and uncheck "Check for server certificate revocation".  For security purposes you will want to get the Certificate issue resolved, but this can be a temporary workaround:

4. To fix the below:

Log on to all machines that are Web Front Ends with the account (very important) that is running the Web Application hosting the PowerPivot Gallery.  If this account cannot log on to that server you have a problem.  It needs to have access to that server.  Once logged on, Open Internet Explorer >Internet Options > Security tab > Trusted Sites > Sites > add the URL to the list of Trusted Sites (may need to log on to the WFE(s) as account running SP-80): http://tschauer2010:80

I have also seen that you need to un-tick "Require server verification (http:s) for all sites in this zone." under Internet Explorer >Internet Options > Security tab > Trusted Sites > Sites.

<SnapshotCaptureLog serverUrl="http://tschauer2010" workbookUrl="http://tschauer2010/PowerPivot%20Gallery/PowerPivotWorkbook.xlsx" fileNameBase="thumbnail"
snapshotCount="26" timeout="300">
<Info>'http://tschauer2010:80' was found in a different trust zone (URLZONE_TRUSTED). Attempting to remove from URLZONE_TRUSTED.</Info>
<Info>’http://tschauer2010:80’ was removed from (URLZONE_TRUSTED)</Info>
<Info>’http://tschauer2010:80’ has been added to(URLZONE_INTRANET)</Info>

Refreshing PowerPivot Gallery thumbnails

Comments (13)

  1. Anonymous says:

    #3 AND #4
    Thanks, your page is going directly in my favourites

  2. Andrej: The getsnapshot.exe file should be located on the web front end server. If you are missing the getsnapshot.exe file, the Powerpivotwebapp.wsp solution may not be deployed to the web application. Go to SharePoint Central Administration > System
    Settings > Manage farm solutions to ensure it is deployed.

  3. Awali says:

    #3 fixed it, thank you so much for posting this!

  4. Sebastian Atar says:

    Have you manually run and received this error on PowerView files in gallery?

    Unexpected content type:text/html; charset=utf-8

  5. pankaj says:

    i am getting Illegal redirection to resources outside of the web application:’res://ieframe.dll/navcancl.htm” error. Tried all above but still no luck. I am using Excel 2010 +SP2010 (sql 2008r2) +POWERPIVOT SQL 2012. Data is refreshing and snapshot is
    not capturing..!

  6. Andrej says:

    What if i missing getsnapshot.exe file under C:inetpubwwwrootwssVirtualDirectories80bin ?

  7. ML49448 says:

    Did anyone responded to Sebastian’s error "Unexpected content type:text/html; charset=utf-8" ?

  8. Hi Tom,

    I have a Web application in SharePoint 2013 HTTPS. I have powerpivot installed and it is working fine when I try to access the PowerPivot Gallery with the port number.

    For e.g. https://servername:45176/sites/bi/pp2/Forms/Gallery.aspx. Everything is working fine.

    But when I try to accesss the same https://servername/sites/bi/pp2/Forms/Gallery.aspx without port number I am getting the error.

    Appreciate any help or pointer to fix the issue.

    "Sorry, something went wrong Could not load type ‘Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView’.

    Correlation ID:
    CorelationID details as given below.
    Application error when access /sites/bi/pp/Forms/Gallery.aspx, Error=Could not load type ‘Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView’. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase, Boolean throwOnError)
    at System.Web.UI.TemplateParser.ProcessInheritsAttribute(String baseTypeName, String codeFileBaseTypeName, String src, Assembly assembly) at System.Web.UI.TemplateParser.PostProcessMainDirectiveAttributes(IDictionary parseData)

    System.Web.HttpException: Could not load type ‘Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView’. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase, Boolean throwOnError) at System.Web.UI.TemplateParser.ProcessInheritsAttribute(String
    baseTypeName, String codeFileBaseTypeName, String src, Assembly assembly) at System.Web.UI.TemplateParser.PostProcessMainDirectiveAttributes(IDictionary parseData)

    Getting Error Message for Exception System.Web.HttpParseException (0x80004005): Could not load type ‘Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView’. —> System.Web.HttpParseException (0x80004005): Could not load type ‘Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView’.
    —> System.Web.HttpException (0x80004005): Could not load type ‘Microsoft.AnalysisServices.SPAddin.ReportGallery.ReportGalleryView’.



  9. NickThoman says:

    Do you just need to do the disableloopback check on your WFE or all SharePoint servers in your farm?

  10. NickThoman says:

    NM…. see your comment in a post…. all WFE

  11. anonymouscommenter says:

    En esta ocasión os dejo una nueva referencia a un artículo del equipo de PowerPivot en el que se detallan

  12. Anonymous says:

    Any word on how to resolve this issue on a SharePoint 2016 farm? I can’t locate a GallerySnapshot.exe or GetSnapshot.exe file on my 2016 servers. Is this because they moved the Excel Services functionality to Office Online Server?