Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sbacalso
Frequent Visitor

combine excel files with different numbers of sheets

Hi,

 

Newbie here. 

I have a Multiple excel files that I want to Load using get data (Folder) and Merge/Append them all in to one Table.  but have some challenges.

 

1. The excel files have different number of sheets and it keeps on adding. 

2. Only the 1st sheet of the excel file have Header Name on it and the rest don't. 

 

Thank you. 

 

 

 

 

1 ACCEPTED SOLUTION

Hi there

here is a great video by Avi who shows you how to do it

https://www.youtube.com/watch?v=9sfCDCpWTfc




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi there

This can be done and should be achieved using the loading using the Folder Option because it should not look at the sheet names.

There are multiple ways to do this, it all depends on what will work for you. It depends on your requirements.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

 

@GilbertQThank you so much for your response. 

 

Is there any tutorial/reference where I can find in our forum regarding this? Thanks

 

Hi there

here is a great video by Avi who shows you how to do it

https://www.youtube.com/watch?v=9sfCDCpWTfc




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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