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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors