FIXED – PowerPivot Scheduled Data Refresh – Call to Excel Services returned an error.

This issue is fixed in SharePoint 2013 SP1 (Released Feb 25th 2014): Update center for Office, Office servers, and related productshttp://technet.microsoft.com/en-US/office/ee748587.aspx    Issue: "Call to Excel Services returned an error" when performing a Scheduled Data Refresh. In the ULS logs,  you will see: w3wp.exe (0x0A28)            0x0DB8  PowerPivot Service             Data Refresh        99           High                EXCEPTION: System.InvalidOperationException: Call to Excel…

8

SharePoint 2010 SQL 2012 SP1: Procedure or function UpdateRunProcessTimeWindow has too many arguments specified.

Issue: After upgrading your SharePoint 2010 PowerPivot server to be at SQL 2012 SP1 level you get data refresh failures and this error in the logs: EXCEPTION: Microsoft.AnalysisServices.SharePoint.Integration.Redirector.RedirectorException: This request could not be redirected to a PowerPivot for SharePoint server. An internal error occurred. Please look in the SharePoint logs for more information or contact…

0

Excel Services – Maximum number of allowed sessions error

You may receive the following error when trying to view an Excel chart or graph on a website using Excel Services in SharePoint:     The maximum number of allowed sessions per user has been exceeded. The operation cannot be completed.   To fix this error, go to SharePoint Central Administration > Application Management >…

0

Excel Services 2013 issue with IE 11.0.9600.16438 – UPDATE

There appears to be an issue with SharePoint 2013 Excel Services when using IE 11 (11.0.9600.16438).  As noted in the comments below, the issue is resolved by installing the October 2013 Cumulative Update for SharePoint 2013: Description of the SharePoint Server 2013 cumulative update package (SharePoint server-package): October 26, 2013 http://support.microsoft.com/default.aspx?scid=kb;EN-US;2825647 See this blog for detail…


Excel Services 2010 & 2013 – Kerberos Configuration

Configuring Kerberos for Excel Services is a two step process; Information Gathering and Configuration. Step 1: Information Gathering: 1. Account running “Excel Services Application Web Service Application“: In this example: ECSSvc. Central Administration > Security > Configure service accounts 2.  Account running “Claims to Windows Token Service“:  In this example: Local System. Central Administration >…

11

"Cannot convert claims to windows token" "Could not retrieve a valid windows identity " "UPN is required when Kerberos constrained delegation is used"

For awhile now, we here at PowerPivot for SharePoint Support have seen a variety of Claims Identity/Windows Token/UPN errors.  Primarily with PowerPivot failing to refresh a workbook in the browser. But recently, I noticed another product presenting this error. In the ULS logs, you will see: 10/29/2013 10:11:28.57 w3wp.exe (0x1DA4) 0x33F4 SharePoint Foundation Claims Authentication bz7l Medium SPSecurityContext.WindowsIdentity: Could not retrieve a…

3

Excel Services – Query Warning

   You may receive the following warning dialog box when opening a workbook using Excel Services in SharePoint:     Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries?   To suppress this and other warnings from Excel Services, go to SharePoint Central Administration…

5

What is PowerPivot for SharePoint? Part 2.

Now that we have a PowerPivot workbook in the Excel Rich Client, we are ready to publish that workbook to SharePoint. In “What is Power Pivot for SharePoint? Part 1” I discussed the Data Model and how it is a database inside of Excel.  When you publish/upload a regular Excel workbook to SharePoint, that file gets chunked up…

6

What is PowerPivot for SharePoint? Part 1.

I find myself explaining PowerPivot to customers over and over.  Most understand parts of how it works but not the whole story.  I will touch on two parts; PowerPivot for Excel and PowerPivot for SharePoint. Part 1: PowerPivot for Excel PowerPivot for SharePoint is nothing without the Excel Rich Client and the PowerPivot Add-in.  Pre-Excel…

0

PowerPivot for SharePoint – Schedule Data Refresh Error: "A schedule cannot be enabled for a workbook with no external data sources."

If you come across this error when trying to perform a scheduled data refresh: “A schedule cannot be enabled for a workbook with no external data sources.” This is because the Data Model cannot be created on the PowerPivot Server. Your probably have two questions. 1. What is a “Data Model”. The Data Model is…

7