Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Ashish_kumar12
Helper I
Helper I

How to Merge More than 15 excel files in Power Query

‎03-20-2021 12:02 PM

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

Labels:
Message 1 of 3
1,904 Views
0
1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

‎03-20-2021 04:08 PM

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


* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

Message 2 of 3
1,853 Views
2 REPLIES 2
Ashish_Mathur
Super User
Super User

‎03-20-2021 08:33 PM

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 3 of 3
1,841 Views
MattAllington
Community Champion
Community Champion

‎03-20-2021 04:08 PM

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


* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.
Message 2 of 3
1,854 Views

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All