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 spent hours troubleshooting this from all the suggestions. I was doing get data from folder. All files were excel. It would read the first dataset and error on the others. The end result is that I had to make all the files have the same tab name. Frustrating that the tab name in the workbook was even an issue.
If every excel has the data on the same sheet you can fix it easily using transform. in the example below it's the first (0) sheet
let
Source= Excel.Workbook(Parameter2, null, true),
Sheet1_Sheet = Source{[Item=Source{0}[Item],Kind="Sheet"]}[Data],This took care of my issue. Would have never imagined that to be the problem.
