Hi. I created a Power Query and it worked beautifully with the first 4 spreadsheets, but when I have added the following months spreadsheets to the folder and then tried to Refresh All I get the following error: "We couldn't refresh multiple tables, including 'PAYROLL' from connection 'Query - PAYROLL'. Here's the error message we got:
The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source.
More Details:
OLE DB or ODBC error: [Expression.Error] The key didn't match any rows in the table..
An error occurred while processing table 'PAYROLL 2',
The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source.
More Details:
OLE DB or ODBC error: Exception from HRESULT: 0X80040E4E.
An error occurred while processing table 'PAYROLL',
The current operation was cancelled because another operation in the transaction failed."
What have I done wrong?!
My first thought, and obvious so I'm sure you already went there but, did you check your source data? Did you future proof your query, could be something went haywire because something worked for the current month but not subsequent months. Is this the first time you are using your query since it was created or have you been using it for a while and it just broke?
Hi Jessica - thanks for responding. I thought I had future proofed it, by putting the data source as a folder, so I should just need to add the latest spreadsheets to it, and refresh it and heh ho - it certainly worked when I first ran it (although all those spreadsheets were in the folder when I created the query), but since adding the latest month's spreadsheets and trying to refresh, it just returns the error.
Looking at this with fresh eyes, it looks like it might be a table structure thing. Are tables structured the same in all your sheets? Is there some difference in your new sheet that wasn't accounted for in your query? Do the tables PAYROLL and PAYROLL 2 exist in your new file?
