HI,
steps i have followed below
1) I have configured Performance point services and excel services in sharepoint 2013.
2) I have sharepoint list data.And using Odata power pivot connecting to sharepoint list and generated report in Excel 2013.
i have uploaded document to document library and when i opened the document from library and trying to refresh the report i am getting and issue.
Error:
“an error occured while working on the DataModel in the Workbook.Please try again.”
Please any one help me how to configure this.
Thank you in advance
Mahesh
I would recommend gathering the matching ULS log to find the exact error. This post has information as to debugging based on the ULS error under the section “External data refresh failed error for PowerPivot\Excel Services”
https://blogs.msdn.microsoft.com/how24/2014/08/08/6-known-issues-an…
Also make sure you review how you are accessing the excel files, whether they are with excel services or office web apps you will get a different experience. Â The article below lists the differences.
