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.
Hello all,
Here is my two cents on it and how I fixed it.
Anonymous
Go in the source(power query) and fix it out there. Remove(filter out) all other useless files in the first few steps of the source itself. Because some new sheets in Sharepoints may have errors and if it is already not being filtered out, then it will stop the process and you may never understand why.
ksimpson50502 - if you have hundred files, are they all in the same folder. Irrespective of the sharepoint problem, you have to have all similar sheets for the automation to break. If you have hundred sheets, you should probably maintain different folders for the similar sheets. Similar sheets have similar properties, like following same sheet name and different dates for example. It is very easy to apply a rule in power query and filter it out. If you are able to filter out the whole unneccesary sheets in the Source without "Expanding",(ie, appending all sheets), then you should not face any errors.
CCMK80 c I think we tried the same solution and yes, I do feel the pain. If they can just make it clear what exactly is the error.