"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…

9