Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AnneConway1
Frequent Visitor

Error OLE/DB/ODBC

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. 

 

AnneConway1_0-1669043472620.png

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

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

 

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.