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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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