PowerPivot for SharePoint 2016 Scheduled Data Refresh Error: "The operation has timed out"

UPDATE: 4/25/17: PowerShell to increase timeout included in workaround section. Scenario: You create a PowerPivot workbook with one or more data sources and upload it to SharePoint 2016. You then schedule the workbook to refresh and the refresh fails with the following error: “The operation has timed out”. Cause: This issue is caused by a…

4

Excel Online Cross Forest KCD Data Refresh Not Supported

Scenario: You configure Office Online Server with SharePoint 2013 or SharePoint 2016 and have configured Kerberos Constrained Delegation to a data warehouse to pull business intelligence data for your users. You have two Active Directory domains in separate forests in a 2-way transitive trust configuration (We will call them DomainA in Forest 1 and DomainB in…

0

Excel Services - Query Warning

   You may receive the following warning dialog box when opening a workbook using Excel Services in SharePoint:     Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries?   To suppress this and other warnings from Excel Services, go to SharePoint Central Administration…

9

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…

0