Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power Query Combine Excel data files with different tab names

Hello,  i found information on combining a folder of excel files into a single power query that refreshes as files are loaded and taken out of the folder by creating a funtion in powerquery and appl...
Need Help
Tutorial Requests
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous,

    Based on my test, you could refer to below code in query editor:

     

    (para as text)=>
let
    a = Folder.Files(para){0}
in
    a

    Enter your file path as parameter and it will choose the first sheet automatically:

    Hope it could help you.

     

    Regards,

    Daniel He

     

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He