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
MrPowerBI
Frequent Visitor

Expression.Error: The key did not match any rows in the table

I'm trying to import a query created in Microsoft Access into Power BI, but I get the following error message when trying to do so: Expression.Error: The key did not match any rows in the table.

 

I'm sitting on a local computer and all the files that are connected to the Access query are also local. It worked just fine before, but it seems that the error started ocurring after I installed the Power BI October update.

 

Does anyone have a possible solution for this? I've tried creating the query from scratch again in Access, but I keep getting the same error message.

1 ACCEPTED SOLUTION
daverpitts
Regular Visitor

This seems Bogus I Got the Same - when I clicked Refresh Preview the Table Appeared ! as if by Magic

View solution in original post

3 REPLIES 3
daverpitts
Regular Visitor

This seems Bogus I Got the Same - when I clicked Refresh Preview the Table Appeared ! as if by Magic

I'm getting this same error on a view that i copied in.  I cleared the cache through the options menu but that didnt help.  Basically all my views that i added after i linked to the db are giving me this error.  Any suggestions?

Thanks daverpitts, that quick fix works when that same error reading pop's up when pulling a sharepoint list.

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.

Top Solution Authors
Top Kudoed Authors