PowerPivot Gallery shows Red X's for Icons

Article ID: 2361559 - View products that this article applies to.
Expand all | Collapse all

Symptoms

After publishing PowerPivot workbooks to the PowerPivot Gallery, the gallery shows Red X's instead of an image of the workbook.

Cause

GetSnapshot.exe is unable to render an image to the Gallery.

Resolution

  When a .xlsx is uploaded or published to Gallery, behind the scene, a process (GetSnapshot.exe) is created that ultimately generates the snapshot image (.png file) and saves in C:\Windows\temp. Here are some of the troubleshooting steps for this scenario:

 
1. Make sure Excel services is rendering workbooks.

2. If you you have Internet Explorer 9 installed on your Farm servers you need to install Sql 2008 R2 SP1 for PowerPivot for SharePoint.

a. if you cannot upgrade to SP1 you can manually make the fix with the below steps.

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') ) {


3. A simple test to see if a getsnapshot is being spawned is to: 

a. start task manager on your Web Frong End and click “show processes from all users” 

b. go to the document library and go to view “all documents” and just edit properties. This should cause GetSnapshot.exe to fire and you should see it under task manager and can see the account it is running under

4.  You can run GetSnapshot.exe manually and pass in parameters site, url, guid (note guid can be whatever). One caveat though is that the .info and .png file are created in the user’s local temp directory if they are logged in (as I was)…otherwise it will be saved in the c:\windows\temp. You cannot use this method to manually create/replace a thumbnail. This will only tell you if GetSnapshot failed (maybe b/c it took too long or something)

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

5. Look in C:\Windows\Temp for the thumbnail (.png) and the log file .INFO; .INFO file should report success or failure messages 

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

7.  The workbook might contain more than one data source. If so, a thumbnail will not be generated. 

8. 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. 

9. Verify Alternate Access Mappings are setup correctly.

10. Add the PowerPivot site to the trusted intranet sites for the account running Getsnapshot.exe

11. Disable loopback check.  http://support.microsoft.com/kb/926642

12. Remove the check box for refresh on open in the workbook connection properties

13. Open Advanced Settings for the Document library(PowerPivot Gallery). Under Opening documents in the browser change the setting to "open in the Browser".

14. Disable Internet Explorer Enhanced Security Configuration in Server Manager > Configure IE ESC


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2361559 - Last Review: November 19, 2013 - Revision: 4.0
Applies to
  • Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010
Keywords: 
KB2361559

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com