Refresh not updating all rows in Excel Sheet

All forum topics
Previous Topic
Next Topic

Hello,

I have been using an excel file with Payroll data. All worked well untill today when I added last weeks data to the bottom of the excel sheet im using to refresh power BI. It wont update the last 18 Rows in the file? Theres only 2345 Rows. When I hit refresh, i look in the bottom of the data page and it shows, not sure why its doing this