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

[MrPowerBI]

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.

[daverpitts · Accepted solution]

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

[TvptRslv]

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?

[GerryFlanagan]

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