Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Excel spreadsheet not importing all rows

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'v...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

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

  • Anonymous's avatar
    Anonymous
    3 years ago

    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"

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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"

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    *** 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. 😀