Excel spreadsheet not importing all rows

[Blondyvl]

I have an excel spreadsheet with 1375 rows of data including the header, however it will only import 1364 rows of the data, nine rows of data from the bottom of the spreadsheet will not import. 
I've tried control + end to see if the last cell is the last row end and it is the last cell of the data I want to import. 
I've tried filtering the data in a Z-A rather than A-Z to see if it it something in one of the last nine rows that is stopping it from importing, but it just didn't import the last nine rows of data starting with A rather than Z. 

I have tried deleting 9 rows from the bottom of the data then it only imports 1355 rows? 

still missing the nine rows from the bottom of the spreadsheet.

I've copied the data pasted as text to create new csv files, then linked and importing into my dashboard- still the bottom nine rows will not import. 

As a work around it has allowed me to add nine rows of test data to the bottom of the spreadsheet, which I don't want to import, refreshed and all 1374 rows have now imported even though the spreadsheet has 1383 rows of data. I can not work out what I am missing/ doing wrong?  

Please can anyone help. 
Many  thanks 

[Greg_Deckler · Accepted solution]

@Blondyvl Can you go into Advanced Editor, copy the code and paste it here?

[Greg_Deckler · Accepted solution]

@Blondyvl Can you go into Advanced Editor, copy the code and paste it here?

[Blondyvl]

*** AMAZING, you are fantastic ****, thank you so much, i compared both codes -  deleted the two rows from the code  -  #"Removed Bottom Rows" = Table.RemoveLastN(#"Added Conditional Column7",2),
#"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",7). 

It's working as it should.  serioulsy you have made my day.  Thanks again. 😀

[Blondyvl · Accepted solution]

Due to the data i can't paste it all on here  - however looking at this section i have just noticed this - I changed the header of the unique identifer this morning. im going to check this code with another set of data that is uploading ok.  Thanks for pointing me in the right direction. 🙂

#"Removed Bottom Rows" = Table.RemoveLastN(#"Added Conditional Column7",2),
#"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",7),
#"Renamed Columns1" = Table.RenameColumns(#"Removed Bottom Rows1",{{"********", "*********"}})
in
#"Renamed Columns1"