Forum Discussion

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago
Solved

Expression.Error: The key did not match any rows in the table

I have a data set that has refreshed successfully in the past. It was built 3 days ago and refreshed fine for two days. Now I cannot refresh it either on the desktop version or from services. The err...
Need Help
  • tonysellars's avatar
    tonysellars
    10 years ago

    Ran into this issue myself within the Power BI Desktop and was able to resolve the issue through the following:

     

    1. Select Edit Queries from the menu to open the Query Editor
    2. Use the left hand menu to select one of the queries having the issue (will have the triangular warning sign)
    3. On the applied steps menu at the right select the source step.
    4. 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 -

tonysellars's avatar
tonysellars
Icon for Advocate II rankAdvocate II
10 years ago

Ran into this issue myself within the Power BI Desktop and was able to resolve the issue through the following:

 

  1. Select Edit Queries from the menu to open the Query Editor
  2. Use the left hand menu to select one of the queries having the issue (will have the triangular warning sign)
  3. On the applied steps menu at the right select the source step.
  4. 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 -

danica00's avatar
danica00
Regular Visitor
2 years ago

Thanks for providing a solution! I've tried this as well but I have an issue where the data takes a very long time to load. This is because the table is a reference table from a RaaS API connection. Do you know if this is the reason the key did not match any rows in the table or am I dealing with a different beast?