Forum Discussion
Excel Power Query Wont Load All Rows
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
YWolf970 Thank you, not necessary if you are sure. Your query is connection only or with loading to data model?