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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi awiefoong ,

 

Try copying data in the new (xlsx or csv) file and then get data from this (new) file. Does the error persist?

As mentioned by Jimmy801 this is most likely an issue with the file itself, not PBI or connector issue. Can you export it in a different format (e.g. csv vs. xls)? If yes, try this too.

 

Kind regards,

JB 

awiefoong's avatar
awiefoong
Frequent Visitor
5 years ago

Thanks Anonymous. Yes it is an issue with the Excel file. I convert 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.