billytheking on Mon, 19 Aug 2013 16:20:56
I'm getting the following error on a workbook's PowerPivot Data Refresh in SharePoint 2010:
Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: The remote server returned an error: (401) Unauthorized.;The logon attempt failed
It is using a Data Feed from a SharePoint List (.atomsvc) that is stored in a Data Feed Library. I have the Unattended Service Account set to the Farm Account. This account has Full Control on the SharePoint site. If I refresh the data from the Excel Client, it works fine.
Any help would be much appreciated.
Elvis Long on Wed, 21 Aug 2013 09:40:50
According to the description, it seem this issue is more realated to account permission. Please check that the Unattended Service Account have sufficient permission access to the data source.
In addition, please also take a look at the following article:
Configure Excel Services data refresh by using the unattended service account in SharePoint Server 2013: http://technet.microsoft.com/en-us/library/hh525344.aspx