Excel Services & F5 – Excel Web Access Web Parts Not Rendering.

I have worked with several customers who were experiencing strange behavior when viewing a SharePoint Dashboard containing multiple Excel Services Web Parts. In one support case, a customer had 16 Excel Web Access Web Parts.  Some users would see all 16 Web Parts and others would only see 15.  The question was, “Why do some users…

1

PowerPivot for SharePoint – Gallery Thumbnails Not Rendering

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 In the SharePoint site collection, click…

8

PowerPivot for SharePoint – Scheduled Refresh to Oracle, IBMDB2, Teradata, SQL (en-US)

PowerPivot for SharePoint – Scheduled Refresh to Oracle, IBMDB2, SQL (en-US) Here is how to create a Scheduled Refresh to an Database that does not accept domain credentials in PowerPivot: Create 2 SSS IDs:   1. PowerPivotDataRefresh   a. Create a SSS application using Group leaving application Page URL to none. b. Utilize the Windows Username/Password template….

4

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…

12