Forum Discussion
Error returned: 'OLE DB or ODBC error: [Expression Error] The key didn't match any rows in the table
Anonymous
A typical case would be when you connect to an datasource and your Query attempts to access a table or column that does not exist in your datasource. Check if there is any table/column names are not matching.Reference:
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
I faced the same issue last week, any successes?
I haven't found a way to make this error message useful, as it usually just tells you there is a problem but not what the problem really is. I have many files sourced in my query, so if I notice one time it doesn't refresh properly, I go back and check the files that have been modified since the last refresh. I check to make sure all columns and rows are unhidden, have the same naming convention and order, and the worksheet names in the workbook are all the same.
I have confirmed that I do not have many tables or files, yet I encountered an error indicating limited memory usage. Upon checking my workspace memory, I noticed it shows a large amount of memory. However, I believe this error may be referring to memory per query execution, which I am unsure how to check