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!
If these excel files has similar table structure, you can try to use folder connector to get multiple files at same time and merge them at same time.
If these files has different structure and you only want to extract part of columns from files, please share some sample data with a pbix file and expect result snapshot to help us test and clarify your requirement.