Forum Discussion

twister8889's avatar
twister8889
Icon for Helper V rankHelper V
5 years ago
Solved

Alternative to load multiples files excel

Hi guys,   I have an import to power bi, the folder that contains multiples excel files, in this folder has 294 files, 390 MB the total size. I need to only remove all columns and group by file nam...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    twister8889 

     

    Loading data from Excel files is generally slower than loading files in other format (e.g. csv or txt).

     

    Probably the group by that you are doing is even slower considering the amount of data you load.

     

    One good technique it to use Table.Buffer or List.Buffer to load data in memory and then carry on with other calculations / aggregations

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, twister8889 

You can refer the video in  A cleaner, better and faster way to bulk import files in Power BI: Csv.Document and Excel.Workbook. Curbal has shared some methods to faster import multiple csv or excel files, It may help you solve your problem.

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.