Forum Discussion
Ralugnic
Mar 01, 2020Copper Contributor
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...
Abiola1
Mar 01, 2020MVP
Hello,
Normally, when you import data that's formatted in Excel Tables into Power Query, all the data will be successfully imported without restriction.
Just to try and verify: copy all the data in that particular Excel workbook and paste in a new workbook. Format in Excel Table and import to the PQ. Kindly let me know if the issue persist or not.
Regards
Normally, when you import data that's formatted in Excel Tables into Power Query, all the data will be successfully imported without restriction.
Just to try and verify: copy all the data in that particular Excel workbook and paste in a new workbook. Format in Excel Table and import to the PQ. Kindly let me know if the issue persist or not.
Regards