Excel Services & PowerPivot for SharePoint

Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.

PowerPivot for SharePoint - Gallery Thumbnails Not Rendering

PowerPivot for SharePoint - Gallery Thumbnails Not Rendering

  • Comments 7
  • Likes

Many customers have reported after uploading a workbook to the PowerPivot Gallery, the thumbnails are not rendering:

Snapshots will not work if you have chosen to open the workbooks in the Client application. To remedy this, follow the below instructions:

To set the default open behavior for site collections

  1. In the SharePoint site collection, click Site Actions, and then click Site Settings.
  2. On the Site Settings page, under Site Collection Administration, click Site Collection Features.
  3. 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

  1. On the <document library>: All Documents page, under Library Tools, click Library.
  2. In the library toolbar, click Library Settings.
  3. On the Document Library Settings page, click Advanced Settings.
  4. 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).
  5. 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
  6. 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.

If the above do not work:

You need to invoke the Getshapshot.exe (which is located here: C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin>GetSnapshot.exe)

        *Note: Browse to C:\inetpub\wwwroot\wss\VirtualDirectories\80\bin>GetSnapshot.exe and make sure it is 50/56kb.  I have seen instances where is is corrupt 0kb and it needs to be replaced.

To invoke the Getsnapshot.exe (re-title a workbook) via:

PowerPivot Gallery > Select a Report > Documents > Edit Properties > Title (give the workbook a title):    

                                           

If these steps do not remedy this issue, please move onto my next article:

Invoking and Analyzing the Getsnapshot.exe
http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2012/12/06/invoking-and-analyzing-the-getsnapshot-exe.aspx

 

Comments
  • While I am working on SP2013 with SQL2012 Sp1. The powerview can render out , but Excel just show the error icon.

  • Bob: We had this issue with the same versions of the software as you had. Disabling loopback checks worked for us. More information here: http://sp-vinod.blogspot.com.au/2013/03/disable-loop-back-check-in-sharepoint.html
    Good luck!

  • Hi tom, do you mind sending me GallerySnapshot.exe? Mine became 0 KB and I do not know where I could get it. Thanks!

  • PPIV 2012 + SP2010 (SQL 2008R2) + EXCEL 2010. I am getting same error. tried many options but still no luck. data is refreshing but not reflecting in browser. Please guide @ d earliest

  • Have tried this with a test PowerView report in my PowerPivot Gallery and tried these methods to no avail. I created the site using port 80 the host header is the same as the internal FQDN its something like sharepointbidev.domain.com. The test above throws the "System.TimeoutException: The operation has timed out" error- have tried the DisableLoopBackCheck as well as the "BackConnectionHostNames" entries still no good. Site is in "trusted sites" as well.

  • Jason L.: Thumbnails are not supported for Power View reports embedded in Excel workbooks. See this blog post for workarounds: http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2014/08/14/power-view-sheets-cause-snapshot-generation-to-fail-in-powerpivot-gallery.aspx

  • Thanks for sharing.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment