Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Error "Key didn't match any rows" for VIEW - cannot refresh my reports

Hi all,   Thanks for reading   I've been trying to build a report recently and when refreshing, I have been facing the error "The key didn't match any rows in the table  Details: Key=Record T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous From this thread it appears a fix works in Power Query -> https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/td-p/155986

 
"
altomost Frequent Visitor
Frequent Visitor
Re: Expression Error.: The key didn't match any rows in the table
 
‎09-06-2017 01:28 AM

you can make this error occur if you:

  1. connect to a database
  2. select any table and load it
  3. click home - edit queries
  4. click source under applied steps
  5. click advanced options in the popup
  6. type SQL statement e.g. select * from [yourtablename]
  7. click ok
  8. click close and apply
  9. You now see the error above (Expression.Error: The key didn't match any rows in the table)

Solution

  1. click home - edit queries
  2. under applied steps, remove navigation
  3. click close and apply
  4. The error is fixed"
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I have seen this thread but for some reason there is no option to insert an SQL statement on the source, possibly because it is an Impala source?


    • TeigeGao's avatar
      TeigeGao
      Icon for Solution Sage rankSolution Sage
      7 years ago

      Hi Anonymous ,

      Yes, Impala source still not supports a SQL Query.

      Best Regards,

      Teige

Related content