Forum Discussion
get data from multiple Excel sheets in one file hosted in Sharepoint
Note that you also could have just clicked on the "Binay" hyperlink to drill into the Excel workbook (and not create all the extra stuff that comes from the Combine & Transform functionality.
Pat
I think I have solved it!! Noting here for anyone else passing by .....
Once you filter on your specific file from the SharePoint folder ,
remove all columns except "Binary"
(1) Click "Combine files" button.
in the "Combine files" pop out window
(2) Right click on the file ( in my case called perameter2 ... Not sure why ... )
and select transform data
Now you have the same starting point as a local Excel file, and it will allow a scheduled refresh !!!
Note that you also could have just clicked on the "Binay" hyperlink to drill into the Excel workbook (and not create all the extra stuff that comes from the Combine & Transform functionality.
Pat
Hi Pat
now I see this also "Right click" on "Binary" and select drilldown !!
thanks - thats even quicker