Share via

SharePoint 2010: PowerPivot Gallery Thumbnails/Snapshots Not Rendering

  • Article

Here are some quick steps to hopefully resolve the below error:

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)
**http://technet.microsoft.com/en-us/library/ee837425.aspx

                           

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 you have IE9 on SharePoint Server, thumbnails will not render. Uninstall IE9.

Update: This resolves the IE9 issue:

Microsoft® SQL Server® 2008 R2 Service Pack 1
http://www.microsoft.com/download/en/details.aspx?id=26727

IE9 workaround (if you cannot apply the above update):

In %Common Files%\Microsoft Shared\Web Server Extensions\14\Template\Layouts\PowerPivot you will find a file called ASRGLoader.htm.

Make a copy of the file and call it ASRGLoader.orig.htm (this is so that if you mess up anything you can revert :)

Open asrgloader.html in notepad.

Search for a function called onXLFrameLoad

Replace the line
               if (ewaFrame.document.readyState == ‘complete’) {
with the line

               **if ( (ewaFrame.document.readyState == ‘complete’) || (ewaFrame.document.readyState == ‘interactive’) ) {
**

If the above do not work: You will need to DiasableLoopbackCheck (this is a security from Microsoft, be careful before doing this):

  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key: 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. Quit Registry Editor, and then restart your computer.
  8. PowerPivot Gallery > Select a Report > Documents > Edit Properties > Title (give the workbook a title)

Additional Articles:

Refreshing PowerPivot Gallery thumbnails
http://blogs.msdn.com/b/mtn/archive/2010/10/15/how-to-manually-refresh-powerpivot-gallery-thumbnails.aspx

Snapshots not being taken
http://powerpivotgeek.com/2010/10/24/snapshots-not-being-taken/
**
**There is another issue you might see is:

Gallery specific issues
http://powerpivotgeek.com/troubleshooting/gallery-specific-issues/

Another problem with the Gallery is that a blank thumbnail might be generated and it contains a “lock” icon. In this scenario, GetSnapshot.exe has determined that their might be a possible information disclosure and will not generate the image. This is likely caused by one of the following conditions:

The workbook might not contain any embedded PowerPivot data. If so, a thumbnail will not be generated.

  1. The workbook might contain more than one data source. If so, a thumbnail will not be generated.
  2. The single data source must point (via the “Server=” or “Data source=” property in the connection string) to either (a) the embedded PowerPivot database; or (b) to another workbook (.xlsx) that is contained in the same document library (i.e. the Gallery). If not, a thumbnail will not be generated.
  3. If the file is a .rdl file, then the data source must be embedded in the report and it must use the PowerPivot OLEDB provider and point to a workbook (.xlsx) that is contained in the same document library (i.e. the Gallery). If not, a thumbnail will not be generated.

SQL Server Reporting Services Reports in the PowerPivot Gallery
 http://performancepointblog.com/2009/11/sql-server-reporting-services-reports-in-the-powerpivot-gallery/

**How to: Use PowerPivot Gallery
**http://msdn.microsoft.com/en-us/library/ee637435.aspx