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
NickzNickz
Helper IV
Helper IV

Combine and append data from multiple excel files

Hi..

 

I have multiple excel files and data table in excel file as below. The file name is different each month and years.

NickzNickz_0-1687348405166.png

 

How can I combine and append the data in Power BI. I try to avoid having the data staging files in excel format.

From excel perspective yes I manage to do it. However, there is a requirement to do it in Power BI ....

Anyone can help me on this ...

 

Regards,

NickzNickz

 

 

 

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @NickzNickz 

 

Please check this, there's too much to rewrite it all here

 

Import Multiple Files Containing Multiple Sheets with Power Query • My Online Training Hub

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @NickzNickz 

 

Please check this, there's too much to rewrite it all here

 

Import Multiple Files Containing Multiple Sheets with Power Query • My Online Training Hub

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hi @PhilipTreacy ,

 

Thank you for the link .... I also found another video  https://www.youtube.com/watch?v=OKoWEhb8Yek ... This one is for multiple tables ... Similar process/steps .... 

 

Regards,

NickzNickz

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.