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
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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors