Forum Discussion
Excel Power Query Wont Load All Rows
Maybe this information will help you.
Power Query specifications and limits
* It is always good to know which version of Excel is being used and which operating system is used.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
NikolinoDE using windows 10 64bit and office 2019. I will check out limitation link you shared but I don't think it's that, I have another file that has over 5 million records and it reads it perfectly
- SergeiBaklanOct 05, 2020Diamond Contributor
Do you know why Notepad++ shows line 1,218,272 in status bar if you stay on the last line of the file?
- YWolf970Oct 05, 2020Copper Contributor
SergeiBaklan it shows 1218272 because it was active line, my curser was on this line. I was confirming if power query reads 1st 1218272 lines or randomly reads lines. Turns out it randomly reads rows of data as line 1218272 in notepad++ and 1218272 in powerquery data load to sheet are different (I splitted the records at 1 million rows so these 1218272 rows were loaded into 2 sheets within same workbook).
- SergeiBaklanOct 05, 2020Diamond Contributor
But very left grey column in Notepad++ shows 2 479 724 - it shall be the number of current row on which you stay.