How to Merge More than 15 excel files in Power Query

[Ashish_kumar12]

Hi There ,

Hope you are doing  well.

Can anyone please tell me that how can i merge 15 excel (.xlsx)files in one file in Power Bi desktop ?

I have laod the folder from the source and all the files are appearing however i am not sure what will be the next step to combine all those files .

E.g i have 15 excel files available in "XYZ" folder , I want all those file to be consolidated in one File and Load their data into Power BI Dekstop .

Regards,

Ashish

[Ashish_Mathur]

Hi,

Watch this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.

[MattAllington · Accepted solution]

I cover this in my blog article here https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-2/