Forum Discussion

c5966's avatar
c5966
Icon for Helper I rankHelper I
7 years ago
Solved

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

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.

Need Help
  • SHDJason's avatar
    SHDJason
    7 years ago

    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. 

2 Replies

  • SHDJason's avatar
    SHDJason
    Icon for Advocate II rankAdvocate II
    7 years ago

    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. 

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.