SharePoint Excel data source

• SashaStacyL

  SSC Enthusiast

  Points: 190

  More actions

  June 4, 2016 at 8:52 pm

  #311044

  Can plain excel files with multiple tables in different formats on the same sheet stored in SharePoint be used as a data source? The tables aren't tables in the sense that in excel tables are inserted under the Insert tab. It needs to pull data from existing excel files without having to do anything like converting it to a SharePoint List.

• Joie Andrew

  One Orange Chip

  Points: 27360

  More actions

  June 7, 2016 at 6:10 am

  #1883545

  I don't think so. This has been asked and answered on MS forums and StackOverflow.

  Using an Excel file on a SharePoint as a datasource

  https://social.msdn.microsoft.com/Forums/en-US/20aa7173-ee56-4f32-aa85-a97c2b75b33a/using-an-excel-file-on-a-sharepoint-as-a-datasource?forum=sqlreportingservices

  Can SSRS use Excel from Sharepoint document list as data source?

  http://stackoverflow.com/questions/29721247/can-ssrs-use-excel-from-sharepoint-document-list-as-data-source

  Joie Andrew
  "Since 1982"