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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Is there a way to combine files in a folder automatically?

Hello there, I have an API script that produces an CVS report every day which is saved as todays date automatically. So it's one folder full of files. 

At the moment though I have to manually combine these files in that folder. They all have the same columns so there is no cleanup needed. Is there a way through Power Bi to automatically pickup new files in the folder and merge them? I've searched online but I can't find anything. 

1 ACCEPTED SOLUTION

Hi @Anonymous 

 

As you are using the folder connector, when you transform the data in Power BI Desktop, you can click on the Refresh button under Home tab to reimport all the data from this folder. Or in Power Query Editor, you can click on Refresh Preview to refresh the data preview. When you click Apply or Close & Apply, it will reimport data from the folder into the data model. 

 

When you have published the report to Power BI Service, you can add the folder data source to an on-premises data gateway and configure a scheduled refresh on the dataset. Then it is able to be refreshed automatically on the service.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

If by CVS you meant CSV files, then read this - Combine CSV files in Power Query


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

@Anonymous , You imported files using the folder option?

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak 

I did yes, so all the files are then imported and I can manually combine them when I transform the data. I'm just wondering if this can be automated? 

Hi @Anonymous 

 

As you are using the folder connector, when you transform the data in Power BI Desktop, you can click on the Refresh button under Home tab to reimport all the data from this folder. Or in Power Query Editor, you can click on Refresh Preview to refresh the data preview. When you click Apply or Close & Apply, it will reimport data from the folder into the data model. 

 

When you have published the report to Power BI Service, you can add the folder data source to an on-premises data gateway and configure a scheduled refresh on the dataset. Then it is able to be refreshed automatically on the service.

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

Anonymous
Not applicable

Thank you @v-jingzhang I was over complicating it thinking that new files wouldn't automatically combine if you have a selected folder. It's actually a lot more straightforward than I thought it was and it's working. 

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.