Forum, Tips & Tricks

Learn tips and tricks and engage in discussions with our blog authors here. It’s all for your benefit and learning. 

You need to log in to create posts and topics.

How to significantly improve performance - CSV vs Excel file

Key finding:

When importing huge ammounts of data from  excel is it much more efficient to change excel file to csv. From the case study Excel files are 4-5 times slower to load than CSV.

More information:

https://www.excelando.co.il/analyzing-power-query-performance-source-large-files/23/#blog