Forum Discussion

MrPowerBI's avatar
MrPowerBI
Frequent Visitor
10 years ago
Solved

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.

Need Help
  • daverpitts's avatar
    daverpitts
    10 years ago

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

3 Replies

  • daverpitts's avatar
    daverpitts
    Advocate I
    10 years ago

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

    • GerryFlanagan's avatar
      GerryFlanagan
      Microsoft Employee
      10 years ago

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

    • TvptRslv's avatar
      TvptRslv
      New Member
      9 years ago

      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?