Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
you can make this error occur if you:
Solution
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?
Hi @Anonymous ,
Yes, Impala source still not supports a SQL Query.
Best Regards,
Teige
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.