Error OLE/DB/ODBC

[AnneConway1]

Hey Guys, 

Does anyone have any idea how to solve this?I am trying to upload an excel folder with multiple weekly reports. Theyt are all formatted the same way etc, so I am unsure as to why I am seing this. 

[v-easonf-msft · Accepted solution]

Hi, @AnneConway1 

Have you made any changes to your datasource?

You can refer to this  blog.

Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or E... 

You’re probably getting this error because your data source that has been deleted or been renamed and your query attempts to access a table or column that does not exist in your datasource. Please check if there is any table/column names are not matching in the query.

If the errors persist, you can delete the query and rebuild it.

You can also check if solutions in in the following threads work for you.

Expression-Error-The-key-didn-t-match-any-rows-in-the-table 

Power Query error 'The key didn't match any rows in the table.' when combining 

how to resolve Power BI error - the key didn't match any rows in the table 

Best Regards,
Community Support Team _ Eason