Tools and Techniques: Troubleshooting Kerberos in Excel Services and PowerPivot for SharePoint

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 Traffic: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters Registry Value: LogLevel Value Type: REG_DWORD Value Data: 1…


Excel Services Data Refresh Failed. Kerberos.dll bug (Server 2008 pre R2).

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 changed on the server.  The PivotTable was not refreshed.” IMPORTANT: I have also seen the…


PowerPivot for SharePoint – Browser Refresh Fails (Data Refresh not supported in Office Web Apps)

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, and are seeing errors similar to the following: "PivotTable Operation Failed An error occurred while working…


Excel Services 2010 – "Unable to process the request." Maximum Private Bytes size exceeded. Unable to complete the operation.

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 Private Bytes” for some unknown reason.  The ULS logs don’t tell me enough.  I assume “something” is…