Forum Discussion
PowerQuery | Multiple Tabs (in Excel) as Source
Hahaha!
I'm so happy, I think I can go home now and get a good night sleep (we'll technically it's morning).
I may have to thank MarcelBeug for this because I learned this from him long time ago.
The secret with this problem is "Excel.Workbook([Content]))", using that I am able to expose the contents of the workbook.
I found this resource from KenPuls, however this only works witha single source:
https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/
I would want to work with multiple excel files that has multiplle tabs ("Get Data from Folder")
Hahaha!
I'm so happy, I think I can go home now and get a good night sleep (we'll technically it's morning).
I may have to thank MarcelBeug for this because I learned this from him long time ago.
The secret with this problem is "Excel.Workbook([Content]))", using that I am able to expose the contents of the workbook.