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
Target application not found unable to refresh data powerpivot excel
You might have encountered this problem while opening the excel file in your powerpivot gallery
Resolution:
Verify the Claims to Windows Token Service running on your PowerPivot server
Verify the PowerPivot Unattended account is created in the Secure Store Application. If not run the powerpivot configuration tool to create the unattended account.
If you are not using Kerberos, We need to create manually the PowerPivot Unattended Account
Go to Central Administration > Manage Service Application > Secure Store Service
Create New Secure Store Target Application with Target Application ID as PowerPivotUnattendedAccount and Run PowerPivot configuration tool
Restart all SQL Server Analysis Service
Restart SQL Browser Service
Restart IIS
No comments:
Post a Comment