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 -
Advocate IVI just wanted to thank you for your post. It helped me solve my issue.
I have my gateway configured to use a specific user on my SQL Server database. This user did not have db_owner set. Once I set that, my refreshes started working fine. I was thrown off bc the refreshes were working from Power BI Desktop but not in the Service.
Of course, these errors are so cryptic, you could spend a whole week trying to figure out what the heck they mean.
Anyhow, you saved me a lot of time and I thank you.
Good to hear that it helped you to resolve the issue :)