PowerPivot for SharePoint 2016 Gallery Snapshots Fail for SSL Host Header Sites

If you have been following the multiple threads  on issues and changes to the PowerPivot for SharePoint 2016 Gallery Snapshots, you may be aware of an issue where gallery snapshots do not function properly (infinite “hourglass”) for SSL sites when there are multiple sites bound to the same port. While not limited to port 443 we will use a generic port 443…

0

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

The resource object with key ‘DataRefresh_Warning_DataSources’ was not found

UPDATE: 8/16/17 – This issue should be fully resolved with the below patches!! If you have not already installed the following patches on your PowerPivot for SharePoint Analysis Services instance and/or the MSI DO NOT PROCEED WITH THE INSTALLATION! SQL 2012 SP3 CU6 – Resolved (see below) SQL 2012 SP3 CU7 – Resolved (see below) SQL 2014 SP1…

1

Changes to PowerPivot Gallery and Snapshots in SharePoint 2016

Updated 6/9/2017 The PowerPivot Gallery has had some functionality and supportability changes between SharePoint 2013/2010 and SharePoint 2016. This is due to the fact that Excel Services functionality has moved to Office Online Server. While the basic premise of the gallery remains the same and some of the same rules apply, there are some changes…

10