I have created a PivotChart in Excel workbook that fetches data from a SharePoint list using "OData Data Feed". When refreshing the connection in Excel 2013, the updated data is displayed in PivotChart. But when i upload the same to a SharePoint Library and refresh it through Excel Web Access WebPart, it throws an error.
External Data Refresh Failed. Error - An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:
Note -
The library location is added in trusted zone.
Using secure store didn't fix the issue.
0 commentaires:
Enregistrer un commentaire