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.

awiefoong's avatar
awiefoong
Frequent Visitor
5 years ago

Jimmy801 Many thanks for the suggestion. There isn't any filter and I still have no idea what's wrong with the original Excel sheet... But you are right that the data file was exported from system. Hope to hear from someone who has faced similar issue and have solved the problem 😉

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.