Forum Discussion
Combining multiple sheets (but not all) from multiple Excel files in a Sharepoint folder
Filter the files you want to expand and click the Expand icon. You should get this:
Click on the Parameter folder, not any sheet tabs
The next screen will look similar to this:
Filter the KIND column to only show Sheet if that is what you want.
Then filter the Name column to only show the 5 that you want. If one workbook only has 4, it won't matter.
Then click the Expand icon by the data column.
This will expand all 5 sheets (or as many as is available) in all files, but will ignore the sheets you do not want.
Thank you, edhans ! This was exactly the direction I needed.
For my particular case, I used the technique from Chriss Webb's blog to create a custom function to clean the data per sheet before expanding/combining them. I just tweaked it a bit to parameterize the Excel file name in addition to the parameterized worksheet names.
Chris Webb's BI Blog: Combining Data From Multiple Worksheets In The Same Excel Workbook Using Power BI Chris Webb's BI Blog (crossjoin.co.uk)