Excel Services & PowerPivot for SharePoint

Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.

PowerPivot for SharePoint Manual Data Refresh Failing

PowerPivot for SharePoint Manual Data Refresh Failing

  • Comments 3
  • Likes

You might see a scenario where data refresh with PivotTables or slicers or Data > Refresh All Connections are not working, and you are seeing an error in the browser like this:

 You may also find a corresponding error in the SharePoint logs like this one:

“MossHost.TryGetWindowsIdentity: Current identity is ClaimsIdentity. We need to get a WindowsIdentity”

With PowerPivot workbooks viewed in the browser via Excel Services, in order for PivotTables or slicers or Data > Refresh All Connections to work, the C2WTS is utilized. If the C2WTS is being run by a domain account (Microsoft recommended best practice), then that domain account needs a few certain permissions on each of the SharePoint servers where it is running:

  1. The C2WTS domain account must be in the local Administrators group on the SharePoint servers where C2WTS is running
  2. For the SharePoint servers where C2WTS is running, in the server’s local security policy, the C2WTS domain account needs these permissions:
    1. Act as part of the operating system
    2. Impersonate a client after authentication
    3. Log on as a service

To access a server’s Local Security Policy, go to Start > Administrative Tools > Local Security Policy > Local Policies > User Rights Assignment

 

If you do add any of the permissions above for the account that is running the C2WTS, then you will need to restart the C2WTS on each of the SharePoint servers where it is running.

If the account that is running the C2WTS is LOCAL SYSTEM (not recommended), then no further permissions are required.

Comments
  • Hi Jason,

      Is there any process to refresh the data frequently instead of daily in PowerPivot data model

    Thank You,

    Grace

  • Hi Jason,

     Is there any process to refresh the data for every 15 mins like that instead of daily once in PowerPivot data model

    Thank You,

    Grace

  • Hi Grace,

    If you're talking about the 'scheduled data refresh' for PowerPivot workbooks, then Daily is the most frequently that the refresh can be set to execute.

    Jason

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment