Forum Discussion
Excel Power Query Wont Load All Rows
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
Do you know why Notepad++ shows line 1,218,272 in status bar if you stay on the last line of the file?
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).
But very left grey column in Notepad++ shows 2 479 724 - it shall be the number of current row on which you stay.
SergeiBaklan I used slider to get to the bottom, I will update the screenshot as soon I get home