Forum Discussion
Excel 2013 Power Query - issues importing spreadsheet
I’m noticing that when I import a spreadsheet it seems to stop at 20,000 rows. I’ve converted this file into a csv and it seems to import all or the rows. My question is why does it stop at 20k rows w...
There is no formal limit on numbers of rows and 20K in general is not very big number. However, loading of CSV file and Excel one differs dramatically from performance and using of computer resources point of view. See, for example, Comparing The Performance Of CSV And Excel Data Sources In Power Query Perhaps if you wait some minutes on 20K you'll see the progress with Excel file.