cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors