Data view displaying data at the end of sheet

[christianadaa]

I am totally confused as to how this even occured. My data in data view is showing only when I scroll to the end of the sheet. 

Please see below screenshots. What am I missing - is there a fix to this? 

Top of data view: 

Bottom of data view: 

[amitchandak · Accepted solution]

@christianadaa , Seem like your source might have blank row. In power query use delete empty rows and check

Remove Empty and Remove duplicate Rows (Power Query) : https://youtu.be/Hc5bIXkpGVE

https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321a

[christianadaa]

@amitchandak worked perfectly! Thank you so much. Much appreciated.