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 -
Hello tonysellars,
I had same issue and with your trick I manged to fix it.
However, in the next steps of the query i got the following message:
Know how to fix this?
Thx in advance.
Cheers,
Andrea
Advocate IIThe query itself contains a lot of metadata related to the source you are pulling from and it seems that this can get a bit out of whack. The case you are looking at here you have a many different steps you are going through. The issues for this error have typically been in the source step. To see all the steps and see how the query progresses you can take a look at the progression as each step generates a result which is operated agaist by the next step. The original trick to refresh the query, has worked for me and I was glad to see that it seemed to work with Power Query as well as it uses basically the same mechanism. If you do continue to get an error even after refresh, take a look at the advanced editor and see if something jumps out as not being in sync with your source in one of the later steps.
Hope this helps.