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.
After configuring PowerPivot for SharePoint, i am getting a "We cannot locate a server to load the Data Model" error.
Note -
1. SQL Analysis Service(PowerPivot) is in running state.
2. PowerPivot Server has been under Data Model in Excel Service setting.
0 commentaires:
Enregistrer un commentaire