Forum Discussion

Copper Contributor

Oct 05, 2020

Excel Power Query Wont Load All Rows

I have a large file that has 24,79,724 rows of data, but Power Query loads only 12,18,272 Rows, any one knows how to fix this? Below screenshot of Notepad++ shows all the rows. While Power...

excel

Formulas and Functions

NikolinoDE

Platinum Contributor

Oct 05, 2020

YWolf970

Maybe this information will help you.

Power Query specifications and limits

https://support.microsoft.com/en-us/office/power-query-specifications-and-limits-5fb2807c-1b16-4257-aa5b-6793f051a9f4?ui=en-us&rs=en-us&ad=us

* 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)

YWolf970

Copper Contributor

Oct 05, 2020

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