Forum Discussion

awiefoong's avatar
awiefoong
Frequent Visitor
5 years ago
Solved

Not reading the last row in Excel sheet

Hi all, I am having a pretty weird problem: I have monthly data files (around 50 to 60,000 rows) which are saved in a folder and refreshed on a monthly basis. I noticed that Power Query always read ...
Need Help
  • awiefoong's avatar
    awiefoong
    5 years ago

    Thanks edhans I converted the Excel sheet to Table and the problem is solved. Unfortunately it is not the ideal solution as this means there are a couple more steps needed to the exported file.

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

awiefoong - question - is this in an Excel Sheet and just a grid of data or is this in an Excel table? If the latter, is it possible that the last record was inserted below the table and the table didn't auto-expand to include it?

  • awiefoong's avatar
    awiefoong
    Frequent Visitor
    5 years ago

    Thanks edhans I converted the Excel sheet to Table and the problem is solved. Unfortunately it is not the ideal solution as this means there are a couple more steps needed to the exported file.