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

SergeiBaklan

Diamond Contributor

Oct 05, 2020

YWolf970

But very left grey column in Notepad++ shows 2 479 724 - it shall be the number of current row on which you stay.

YWolf970

Copper Contributor

Oct 05, 2020

SergeiBaklan I used slider to get to the bottom, I will update the screenshot as soon I get home

SergeiBaklan
Diamond Contributor
Oct 05, 2020
YWolf970 Thank you, not necessary if you are sure. Your query is connection only or with loading to data model?
- YWolf970
  Copper Contributor
  Oct 05, 2020
  SergeiBaklan Its connection only and I am not loading to data model. I have another file that has about 500k records and I want to do inner join and load data to table.
  
  Attached below screenshot with last active line. I have also added link to the master file in the question.
  - SergeiBaklan
    Diamond Contributor
    Oct 05, 2020
    YWolf970
    
    Thank you for the screenshot. I tried to play with about 2M rows text file, but with only couple of columns - PQ loads everything, into data model as well.
    
    Thus that's not just number of rows, some combination. Did you try to clean the cache in PQ?