Forum Discussion
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 Query shows that their are only 1218272 rows. I have not aplied any filter, you can see that in the screenshot.
I have also tried splitting the file, still it won't load all rows of data. How can I retrieve all data with Power Query.
I am using Windows 10 64bit and Office 2019.
Link to maste file: https://drive.google.com/file/d/1sd6Jq-Wpux1WPgpvO1ciZrWdjGX7x3Fe/view?usp=sharing
Link to excel file (you will need to change source of master file for it to work): https://drive.google.com/file/d/1JXUe4zPaHdL4MqpMoR_gvU-NQ8lMAYQe/view?usp=sharing
Thanks for the help
13 Replies
- If I may point this out to you and at the same time need your help.I would like to ask you not to post the same question in many forums at the same time.This leads to the fact that many people deal with your topic,who could help other people at the same time.Bear in mind that others may also need help and everyone who helps, helps on a volunteer basis.Thank you for your patience and understanding
Nikolino
I know I don't know anything (Socrates)
NikolinoDE noted
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
Do you know why Notepad++ shows line 1,218,272 in status bar if you stay on the last line of the file?
