Forum Discussion
How to Merge More than 15 excel files in Power Query
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
I cover this in my blog article here https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-2/
2 Replies
- MattAllington
Community Champion
I cover this in my blog article here https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-2/
- Ashish_Mathur
Super User
Hi,
Watch this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.