Forum Discussion
Community ChampionExpression.Error: The key did not match any rows in the table
Ran into this issue myself within the Power BI Desktop and was able to resolve the issue through the following:
- Select Edit Queries from the menu to open the Query Editor
- Use the left hand menu to select one of the queries having the issue (will have the triangular warning sign)
- On the applied steps menu at the right select the source step.
- In the top menu bar, select Refresh Preview.
In my case there were several queries having this same issues and the steps above resolved each of them.
Hope this helps -
Just to add to the growing responses on this error.
I have resolved this by using Basic Authentication on the Gateway, rather than Windows. This despite desktop using Windows.
I'm not fully certain how making this change has worked, given some of my Impala datasources were able to refresh on the Server with Windows, but not others.
We re-entered the credentials to the Gateway on Windows authentication and it threw a connection error, upon changing it to Basic it connected and I can now refresh from all Databases the account has access to.
Hope this helps others.