Excel Services – Workbook background is blacking out.

I have seen several cases where the background\parts of Excel workbooks are turning black: Here is an example in the browser: Here is an example from the PowerPivot Gallery: From my experience the W3WP.exe is growing in size and this causes issues with performance.  Many times this is the result of a corrupt workbook.  I like…


PowerPivot Scheduled Data Refresh: "The workbook must be checked out before it can be replaced. You can save this file with another name."

Scenario: You get the following error while running a scheduled data refresh on a PowerPivot workbook:   Problem: The "Require Check Out" option inside of the Document Library Settings > Versioning Settings of any given document library is likely set to "Yes":   Resolution: PowerPivot does not attempt to check out documents when it makes…

0

Excel Services Data Refresh – Using Secure Store with SQL Credentials.

This case may be a one-off, but I wanted to write about it in the event someone else comes across it in the future. Here is the synopsis.  A user was creating an Excel workbook in the rich client using "Use Windows Authentication": When you do that, the connection string looks like: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=AdventureWorks2012;Data Source=Data;Use Procedure for…


Power View sheet causes thumbnail error in PowerPivot Gallery

If you have a workbook with a Power View worksheet that was created in Excel, and you upload that workbook to the PowerPivot Gallery in SharePoint, you may receive a red X instead of a thumbnail because of a failure with the snapshot generation:     This is expected behavior as the snapshot process does…

0

Notification messages of data update failure are not sent when you use the PowerPivot for SharePoint 2013 add-in for SQL Server 2012 SP1 or SQL Server 2014, even after installing CU7.

Issue: This issue with the email notifications was fixed with Cumulative update package 7 for SQL Server 2012 SP1, but we are seeing cases where the email notifications still do not happen, even after installing CU7 for SQL Server 2012 SP1. Cause: The PowerPivot for SharePoint update is not complete until the PowerPivot Configuration Tool…

1

Excel Services 2013 secure store SSID authentication broken if global option EffectiveUserName is set

Summary: If the Excel Services global option "Use the EffectiveUserName" is turned on, then all workbooks that use secure store service ID's (SSID) will not refresh data and can not create connections to the SSAS data sources. So effectively the SSID authentication option is not useable if the EffectiveUserName global option is turned on. ULS entry: ExternalSource.ValidateConnection:…

0

Power View Sheets not rendering in the browser

If you are using a Power View Sheet and it is not rendering in the browser (see below screenshot): You will want to verify if you are using Office Web Apps Server 2013 (WopiFrame.aspx) to render the workbook by examining the URL: URL Example: http://servername/sites/BICenter/_layouts/15/WopiFrame.aspx?sourcedoc=%2Fsites%2FBICenter%2FTest%20PowerPivot%20Gallery%2FPower%2Exlsx&action=view If you are indeed using the WopiFrame.aspx, you will want…


PowerPivot for SharePoint 2013 – Data refresh schedules get disabled automatically

You may encounter PowerPivot data refresh schedules getting automatically disabled in SharePoint 2013. If a schedule gets disabled, you may see one of the following messages when viewing the Data Refresh History page:   The schedule was disabled due to consecutive failures.     The schedule was disabled because the workbook is inactive.   There…

0

PowerPivot for SharePoint 2013 – "A schedule cannot be enabled for a workbook with no external data sources"

You may receive the following error when running a scheduled data refresh on a PowerPivot workbook in SharePoint 2013 running PowerPivot for SharePoint using SQL PowerPivot 2012 SP1:     A schedule cannot be enabled for a workbook with no external data sources.     This can happen when a PowerPivot workbook created in Excel…

2

PowerPivot Scheduled data refresh does not work for first day of the month

Issue: PowerPivot for SharePoint 2010 scheduled data refresh does not work for the first day of the month, and an error is generated every two minutes. ULS shows: PowerPivot Service             Data Refresh                   99 High     EXCEPTION: Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshException: The data refresh job failed because it did not run within the time period allotted for running this schedule…

1