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

Asked By 60 points N/A Posted on -
qa-featured

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.

Try again or contact your system administrator. The following connections failed to refresh: PowerPivot Data

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

SHARE
Best Answer by Nichols Fryman
Answered By 0 points N/A #142613

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

qa-featured

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

Best Answer
Best Answer
Answered By 0 points N/A #197240

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

qa-featured

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

Login/Register to Answer

Related Questions