Merging files which have different format of data tables

[tubemap]

Hi all,

I have faced a tricky question and it would be wondeful to find a soloution here.

I am trying to creat a Query to merge numbe of excel files. The problem is the worksheets from the files in each column has a different name. I am sensing there should be a way to merge them but couldn't find any advice so far.

If you have any idea, please share!

Key point is I do not want to edit them on excel and import to PBI. I'd like them to be edited on PBI!

Thank you in advacne!

[v-cherch-msft]

Hi  @tubemap

Here are some articles for your reference.

https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/m...

https://powerbi.tips/2016/08/load-multiple-excel-xlsx-files/

Regards,

Cherie