Unable to refresh PowerPivot data in SharePoint

Posted on 2012-09-14
Medium Priority
Last Modified: 2012-10-22
I am getting the following error when I try to refresh Power Pivot data in SharePoint 2010.

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

This used to work on a different SharePoint server that we have. Is there some settings on SharePoint that need to be adjusted?
Do the PowerPivot files need to be configured on SharePoint for embedded connections (similar to Excel Services files)?

When I refresh this PowerPivot data in Excel it works.

Thank you
Question by:HappyLana
  • 2

Expert Comment

ID: 38480022
Getting similar error.
I tried/verified all the things I Can Google including running "Claims to Windows Token Service" with Local System Account, and other MSDN forum suggested configurations but of no help.
In my environment PowerPivot database is in different SQL Server than the SharePoint SQL Server.
I downloaded Adventure Works sample database and attached it to the SharePoint SQL server and PowerPivot Excel created using this database seems to refresh within SharePoint without any issues.
It appears that issue is with authentication delegation and may require Kerberos  configuration ( for database in different SQL servers). This is not my first preference.
I will continue to do research and update if I find any thing.

Accepted Solution

HappyLana earned 0 total points
ID: 38505577
We do have Kerberos configured.

With the help of Microsoft and many hours later our Sharepoint admin team was able to fix this issue. They said that the Excel Services were not running on the PowerPivot server. Hope this helps to you, SharePointWarrior.

Author Closing Comment

ID: 38520422
I haven't received any solutions from the group.

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question