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.”

You may see the following error on when trying to schedule a data refresh of a PowerPivot workbook in SharePoint 2016: Sorry, something went wrong.   The SharePoint ULS logs might show the following error: UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exception: Access is denied. This can occur when the account running the PowerPivot System Service in…

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