The following connections failed to refresh PowerPivot Data RRS feed

  • Question

  • I know this question has been asked a thousand times before, but please bear with me. I've tried most of the suggested remedies on the web, but nothing seems to solve my problem.

    3 tier architecture (Web Front End, Application Server and SQL Server 2008 R2)

    We have PowerPivot for SharePoint installed. When I try to set up data refresh, I receive the following error.

    "Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh PowerPivot Data"

    SharePoint 2010 is using the NTLM protocol instead of Kerberos. I am at my wits end, it looks like I might have to switch to Kerberos, but I wonder if it's necessary for such a simple architecture.

    Thanks in advance. Always.

    Monday, February 28, 2011 1:05 PM


All replies