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