Merge multiple (30) csv files with more than 60 MB data

[c5966]

Hi Team,

I would like to have some suggestions from you all reagarding the best option to merge heavy csv files (more than 25 files) more than (50 MB) into Power BI? 

Is there any better way from Python or any other medium where we can merge many csv files to Power BI?

Appreciate your help on this.

Thank you.

[v-yuta-msft]

@c5966 ,

As @SHDJason  mentioned, a simple way is to use folder connector and combine the csv files.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SHDJason · Accepted solution]

The best way that I know of is to use the Folder data source. This can either be local or online (Sharepoint). CSV files with consistent formatting load pretty quick. Hope that helps.