Why are the bottom 3 rows not loading into my data model?

[Shawry]

Hi, 

I have data up until 25th March i.e. for last week's data in a xlsx file. However, only data up until 21st March is loading into my data model from that same file. 

I've tried refreshing multiple times, have checked the query to ensure the bottom rows aren't being deleted. Have tried stepping through the query to review it at previous steps etc and it's just not being loaded in. Other data is loading in fine, just not for this particular file and I can't determine why. 

Have included a few screenshots for reference - can someone spot what's going wrong, or have any ideas?

Thanks!

[AlexanderPrime]

How is the xlsx connected? Is it pulling from a table within Excel or just directly from the worksheet?

If it's pulling from a table, check if the last 3 lines are actually included in the Excel Table as sometimes adding new lines in Excel doesn't automatically continue the table range and you may need to readjust the cell range of the table within Excel.