Skip to main content
cancel
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
Kratchie
Frequent Visitor

Automatically import multiple Excel files by Month/Year in filename

Hi all,

 

Trying to find a good solution to import reports depending on filename (Month/Year)  and it starts from January 2022 for example.

Filename: Report January 2022.xls

 

Then next months should be automatically imported 1st each month like Report February 2022.xls, Report March 2022.xls and all reports should be merged together.

 

Is it possible? 

 

 

 

1 ACCEPTED SOLUTION
jennratten
Super User
Super User

Hello!  You can use the Get Files from Folder connector and choose Transform and Combine.  Then Power Query will set this up in the query editor and combine the data from the files for you.  It's best to have a folder dedicated to only the files that need to be combine for this purpose, but if that's not possible, you'll need to come up with some logic that filters the list of files so that only those needing to be combine remain in the list before they are actually combined.

Power Query will create these for you:

jennratten_0-1671568233933.png

Transformations that need to be made in all files and can be done before the data is combine should be done in the Transform Sample File table (#1) and transformations that need to be done after the data is combine should be added to the additional table (#2).  

jennratten_1-1671568325565.png

 

Here is a link to the documentation that lists the steps for importing data from multiple files in a folder.

https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query... 

Please let me know if you have more questions.

View solution in original post

2 REPLIES 2
Kratchie
Frequent Visitor

Hi @jennratten, sorry for the late reply! Thank you very much for the solution.

jennratten
Super User
Super User

Hello!  You can use the Get Files from Folder connector and choose Transform and Combine.  Then Power Query will set this up in the query editor and combine the data from the files for you.  It's best to have a folder dedicated to only the files that need to be combine for this purpose, but if that's not possible, you'll need to come up with some logic that filters the list of files so that only those needing to be combine remain in the list before they are actually combined.

Power Query will create these for you:

jennratten_0-1671568233933.png

Transformations that need to be made in all files and can be done before the data is combine should be done in the Transform Sample File table (#1) and transformations that need to be done after the data is combine should be added to the additional table (#2).  

jennratten_1-1671568325565.png

 

Here is a link to the documentation that lists the steps for importing data from multiple files in a folder.

https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query... 

Please let me know if you have more questions.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.

Top Kudoed Authors