When opening an Excel workbook (.xlsx) in the browser the error " The workbook cannot be opened " is thrown: This is caused by the account running Excel Services not having proper permissions to the Content Database. When you upload an Excel workbook...

I have encountered the error " Call to Excel Services returned an error " when performing a Scheduled Data Refresh. In several cases, this has been because the PowerPivot connection is using the " SQL Server Native Client " Provider. We recommend...

With SharePoint 2010, you might run into an issue when attempting to create a new PowerPivot Gallery Document from PowerPivot gallery, like this: If you encounter this issue, you may then see the following to errors: The reason for the...

You might see a scenario where data refresh with PivotTables or slicers or Data > Refresh All Connections are not working, and you are seeing an error in the browser like this: You may also find a corresponding error in the SharePoint logs like...

The following applies to SharePoint 2013: 1. Restarting ECS will force a wipe and reload of PowerPivot databases. 2. Any service account needing to interact with the PowerPivot data model needs to be an Administrator on the PowerPivot AS instance...

We have been seeing some issues with customers using PowerPivot workbooks as a source file in new Excel PowerPivot files. There are a variety of errors that can arise from this process, and this blog is intended to provide you with some troubleshooting...

I have troubleshot many Kerberos cases over the years and here are the best techniques and tools that I have used over the years. 1. Kerberos Event Logging (KB here ): Add the following registry value to each machine in the farm that receives Kerberos...

I have worked with many customers who are seeing refresh failures in the Excel Web Access Web Parts in their TFS Dashboard. In most cases, this is caused by not having a Secure Store Service ID set up for Team Foundation Server and that SSS ID has...

I have had several cases where a customer will have Kerberos properly configured but refresh in the browser fails. In the UI, the error will appear. "Unable to get the required information about this cube. The cube might have been reorganized or...

When refreshing in the browser you may come across this error: "External Data Refresh Failed An error occurred while working on the Data Model in the workbook. Please try again. We were unable to refresh one or more data connections in this workbook...

We have been seeing Excel Services/PowerPivot data refresh issues using SharePoint 2013 and Office Web Apps (OWA). Some customers have been running into issues when attempting to refresh data in a PowerPivot workbook on SharePoint 2013 using OWA server...

Issue: ========== Unable to render a workbook in the browser: Unable to process the request - Wait a few minutes and try performing this operation again" Cause: ========== According to the ULS logs, you are exceeding you “Maximum...

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

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

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

Hello Everyone, We have seen an increase in PowerPivot Thumbnail issues. If my blog does not resolve it. You will need to manually invoke the Getsnapshot.exe, rename the “thumbnails.info” file that is generated on the desktop to “thumbnails...