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.   ...
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

daverpitts's avatar
daverpitts
Icon for Advocate I rankAdvocate 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
    Icon for Microsoft Employee rankMicrosoft 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?