Import specific sheet each file by Power Query

[Omer_K]

Dear all,
I have a folder with a lot of Excel files,
Each file contains quite a few sheets and I want to import only a specific sheet of Power Query from all files, unfortunately the moment I try to import a file from the folder using the Power Query is collapse because of the multiple sheets in each file,
I would like to know how to import and upload only a specific sheet (under the same name) from all the files in the folder,

Thank you very much,

Omer

 

[sandy666]

Don't Combine just Edit
then right click on column Content (Binary) and add as new query
To Table
Combine Files
select Sample File Parameter - Ok
Filter by column Name
then Expand column Data

 

[Omer_K]

Dear Sandy,
Thank you so much,
This seems to be the way but unfortunately the file is still crashing due to the size of the files,
I'll have to look for another solution,

thanks anyway

 

[sandy666]

sure
have a nice day