Powerpivot Refresh happens in Desktop Excel but not in sahrepoint 2013

Category: sql server powerpivotsp


UrsAnandh on Wed, 07 Sep 2016 10:11:43

I had created a SASS tabular model and created a pivot table report and loaded it into SharePoint,i am facing issue when i open the report and refresh it ,It is showing the below error,But when i create a schedule refresh it is working fine,

'An error occurred while accessing application id ExcelServicesDataAccess from Secure Store Service. The following connections failed to refresh: '


Martin Kleynhans on Tue, 13 Sep 2016 12:11:11

Provided your service application is working 100% you have to define the data connection account in the secure store service and use the name of your settings as the Target Application for your refresh. - See: https://msdn.microsoft.com/en-us/library/gg413467%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396

There is more to getting this working reliably, like for example: All the steps to provide seamless authentication between SharePoint (Your Presentation Layer) and SQL SSAS (Your Data Layer)

Regards, Martin