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.

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

Hello awiefoong 

 

first check if you somewhere have a function or a filtering step in your query. Could be also something like Table.SelectRows(FirstStep, each true).

If this is not the case then there is probably a problem with your Excel-file. Maybe is a corrupt file created as a export from a third-party software or a xls-file or somehow the reading-range of the Excel-file is wrong.

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy