Forum Discussion
Anonymous
5 years agoNot applicable
Error returned: 'OLE DB or ODBC error: [Expression Error] The key didn't match any rows in the table
Downloaded to latest Power BI Desktop: When uploading new data in Power Query, I am now receiving the following error message which I was not receving prior to upgrading. Query1 Failed to save modif...
- Anonymous5 years ago
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.
ramdasanudas
3 years agoFrequent Visitor
Try to clean the data load cache: File -> Options and Settings -> Options -> Data Load -> Clear cache and Save the file and Load again