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 -

mustafay's avatar
mustafay
New Member
9 years ago

Hi, 

I got same error, in my case excel sheet names were different. After changing to same name the problem solved. 

 

Mustafa Yalcin

Jmenas's avatar
Jmenas
Icon for Advocate III rankAdvocate III
9 years ago

Hi All,

 

It might be resolved but if anyone had this problem with googla Anyltics API.

 

I found that the solution is to add a custom column and transform the query into a normal table. Otherwise power bi service, in my case, will no identify the correct table. 

 

 

Best,

J.

  • joshcomputer1's avatar
    joshcomputer1
    Icon for Helper V rankHelper V
    9 years ago

    I am using power bi that has a dataset of multiple excel spreadsheets (tables) on sharepoint. I had no problems with refresh until....I had to add an additional table to the power query.  I have two issues here...(1. how to fix the refresh 2. how to prevent this from happening as the dataset changes). 

     

     

    1. I get this error and I have followed the steps to resolve.  When I use the desktop app, I hit refresh and everything works fine. It updates without error. When I go to "edit query" to see if there are errors, there are no errors.  All I am going off of is the email I get that says the refresh failed.  How can I narrow it down if there aren't errors?  Is this error occurring for a specific table that I can isolate?

     

    2. What caused this=>  I added a table and created a power query in excel.  When I appended the query to my existing query, what it does is creates a new tab with it appended.  The only problem is that I have the dataset source pointing to the table "master" and now I have a table that is called "appended1".  I have other tabs pointing to a tab called master and now I need to change the reference to appended1.  It seems like I did something wrong with power query, so I went back through that process and tried other options when appending and still got the same result. I see myself having to fix this everytime a new tab is created. How can be more effective with this process?