| The data connection uses Windows Authentication and user credentials could not be delegated |
| Written by Lee Graber |
| Tuesday, 09 February 2010 22:21 |
|
This is one of the two main errors that users could see from Excel Services when using PowerPivot. This is encountered when refreshing PowerPivot data connections or performing an action which requires re-querying the PowerPivot database, such as clicking on a slicer or expanding a node in a pivot table. To debug, some level of understanding of what Excel Services is doing is required. For this, I recommend reading an earlier post on this blog by Dave …http://powerpivotgeek.com/2009/12/11/excel-services-delegation/ . In general, this is an add-on to Dave’s post which is a quick summary of how to debug this error.
|
Author articles
- Testing the Claims To Windows Token Service for different identities
- Cannot add the specified assembly to the global assembly cache
- The data connection uses Windows Authentication and user credentials could not be delegated
- Dashboard Bubble Chart Shows a Red X (fails to load)
- A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
- Recorded webcast - A Preview to PowerPivot Server Best Practices
