0

I'm testing Excel Service via the Excel Web Access Web Part. I managed to make a working sample of a chart that retrieves its data from a SharePoint List. However, for some reason, I can't make a chart that retrieves its data from an external workbook (uploaded in SharePoint) to connect / refresh data.

Is it not supported? Or is there an additional configuration needed?

1

SharePoint List OData Feed is not a supported data source for Excel services in SharePoint on Premise (But is supported in SharePoint online).so you cannot refresh the data in the browser through EWA webpart. Below are the connected data sources for Excel service on premise:

  1. SQL Server tables
  2. SQL Server Analysis Services cubes
  3. OLE DB or ODBC data sources
  4. Data models, such as those that are created in Excel

See this post about supported data sources for On premise

Alternative approach is to create a power pivot chart in the workbook and display it through a EWA webpart. Make sure the workbook is connected to Power Pivot using secure store id instead of authenticated user's credentials. See this post

  • Thanks for the reply. Actually, I'm not working with PowerPivot, just a regular chart. The data is retrieved from another workbook via just an external connection (OLDB). Thanks for the info though! – bloodfire1004 Aug 31 '16 at 7:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.