cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ak1 Frequent Visitor
Frequent Visitor

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

Table=View".

 

I am connecting to a view in our impala database with the advanced editor code below:

 

 

 

let
    Source = Impala.Database("******"),
    zzz_Schema = Source{[Name="zzz",Kind="Schema"]}[Data],
    zzz_results = zzz_Schema{[Name="zzz_results",Kind="View"]}[Data]
in
    zzz_results

 

 

and every night when there is new data inserted into the view and I try to schedule a refresh, it fails with the same error above.

 

The weird thing is, if i run a simple select query on the impala view like so before refreshing:

 

"select * from zzz.zzz_results limit 10"

 

PowerBI refresh runs completely fine and doesn't have the "keys didn't match any rows" issue!

 

I've tried both direct query and import, nothing seems to work so far. 

 

I haven't been able to find anything about connecting to a view and it causing any issues that I am facing so I was wondering if anyone could help at all?

 

Thanks

 

3 REPLIES 3
Super User
Super User

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

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

 
"
altomost Frequent Visitor
Frequent Visitor
Re: Expression Error.: The key didn't match any rows in the table

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"
Near SE WI? Join our PUG Milwaukee Brew City PUG
ak1 Frequent Visitor
Frequent Visitor

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

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?


Capture.PNG

Community Support Team
Community Support Team

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

Hi @ak1 ,

Yes, Impala source still not supports a SQL Query.

Best Regards,

Teige

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 247 members 2,887 guests
Please welcome our newest community members: