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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors