I have a query that pulls in all excel files in a folder that contains a single spreadsheet of sales for every month. The average row in each on is around 55,000. Everything has been great until recently after adding the latest month sales I seem to be missing data.
I filter the appended data set to that month I am missing almost 10,000 rows as the queiry only counts 59k but the spreadsheat actually has 68k.
This is the first month this as happened. I have looked at the file and right at the row it cuts off and there is nothing wrong with the data, I don't recieve any warnings or issues when I refresh the data. I have tried removing two months of sheat from earlier years and refreshing to see if it was a limitation.
Nnot sure what else to troubleshoot, any ideas would be very appreciated!!
