Failed to refresh data connection in Power Pivot Data of SharePoint 2010

Asked By abbigailantonia 60 points N/A Posted on - 10/06/2012

Hi Experts,

I have received an error with Sharepoint 2010 in Power Pivot workbook.

I published it, and while interacting I received an error message. The screenshot of the error message is as under.

It indicates that it has failed to refresh data connection.

Have you any idea about this refreshment?

Why is it necessary?

Please help.

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

Learn more about data refresh

OK

• Status: Open
• Question Views: 1665
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SharePoint

Best Answer by Nichols Fryman

Go To Solution

Answered By Nicke Baker 0 points N/A #142613

Failed to refresh data connection in Power Pivot Data of SharePoint 2010

Hello Abbigail,

When creating a trusted file location, you will need to ensure that the trusted data connection libraries are embedded as well as selected. That is very crucial in order to enable Powerpivot access in a workbook. Also make sure that you have cleared the checkbox in case the Refresh warning has been enabled.

Regards,

Nicke

About Nicke Baker

Questions
0

Answers
671

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 10/18/2012
• Question Category: MS SharePoint

Best Answer

Best Answer

Answered By Nichols Fryman 15 points N/A #197240

Failed to refresh data connection in Power Pivot Data of SharePoint 2010

Hi Abbigailantonia,
The error is because some of the system settings are missing.
To resolve this error follow the steps mentioned below:
1) Click 'Start', Click 'All Programs'
2) Click 'SharePoint 2010 Products'
3) Click 'SharePoint 2010 Management Shell', Click 'Run as Administrator'
4) Type 'Get-SpServiceInstance', '$claims=get-spserviceinstance-identity'
5) Set the value '$claims.service.ProcessIdentity.CurrentIdentityType=0'
6) Type the commands, $claims.Service.ProcessIdentity.Update(), $claims.ProcessIdentity.Deploy() and press enter
7) After the process is completed, reboot the server and test the Power Pivot workbook

About Nichols Fryman

Questions
0

Answers
701

Best Answers
99

• Vote Up 0 Vote Down

• Posted on - 11/21/2013
• Question Category: MS SharePoint