Forum Discussion
880 MB CSV File
Hey Hey, I have a 880 MB CSV which holds +- 17.000.000 rows. I want to make a selection but unfortunately i get " error, not enough memory". Does anybody know how to work with large CSV files...
Anonymous - Hard to troubleshoot something like that, how much memory do you have? Not sure what you mean by "trying to make a selection". I have worked with large CSV files in the 5-6 million row range.
One thing to check, go to File | Options and settings | Options. In Data Load, uncheck Auto date/time for new files. Also uncheck this under Data Load for the CURRENT FILE. Save your PBIX and refresh.