PowerPivot for SharePoint 2016 error “We cannot locate a server to load the workbook Data Model”

Scenario: You install PowerPivot for SharePoint 2016 (or PowerBI Report Server) and use SQL 2017 as the data model server (Analysis Services in SharePoint mode). You have configured Office Online Server and all of the other dependencies to properly render workbooks and slice data, but you still receive the following error when you attempt the…

0

PowerPivot for SharePoint 2016 – Error when trying to schedule a data refresh: “Sorry, something went wrong” or “A schedule cannot be enabled for a workbook with no external data sources”

You may see the following error when trying to schedule a data refresh of a PowerPivot workbook in SharePoint 2016: Sorry, something went wrong. Or you may see the following error: A schedule cannot be enabled for a workbook with no external data sources   The SharePoint ULS logs might show the following error: UserProfileDBCache_WCFLogging…

0

PowerPivot for SharePoint 2016 – Email notifications are not sent for scheduled data refresh failures

You may encounter an issue with email notifications not getting sent for scheduled data refresh failures of PowerPivot workbooks in PowerPivot for SharePoint 2016. This error is caused by a bug in PowerPivot. The fix has been released in the sppowerpivot16.msi file in the SQL Server 2016 SP2 Feature Pack available here: https://www.microsoft.com/en-us/download/details.aspx?id=56833

0

PowerPivot for SharePoint 2016 – Scheduled Data Refresh error: “The virtual path ‘/……xlsx’ maps to another application, which is not allowed.”

You may receive the following error when running a scheduled data refresh of a PowerPivot workbook in SharePoint 2016:     The virtual path ‘/……xlsx’ maps to another application, which is not allowed.   After this error occurs, the schedule gets disabled and the schedule settings are deleted. The schedule keeps getting disabled even if…

0

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

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