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.
did you ever figure this out or get an answer? i have the same issue. it tells me i have an error but not what or where it is.
In my case, I was pulling data from a folder containing multiple Excel files. The issue was that my query was looking for a 'table' within the Excel file called Table1, and in a couple of cases the Excel table had a different name. It would be helpful though if PBI at least told you which file it had failed on!