Queries blocked by error

[olliehernandez]

I'm trying to update some data and I'm getting an error message showing that the queries are blocked by the following errors:

the key didn't match any rows in the table.

All that was done was editing names within my table.  Any ideas on how to resolve this to load the new data?

[jennratten · Accepted solution]

Hello - this error is usually referring to an object from which you originally obtained data, whose name is explicity referenced in the script, but not that name cannot be found in the source.  

For example, if I wanted to get the records for "Tasks - Today" in the snip below, the script for this step would look like this: 

#"Filtered Rows"{[Name="Tasks - Today",Kind="Table"]}[Data]

However, I replace "Tasks - Today" with "Bugs - Today" in the script, I get the mentioned error because I am trying to get data from an explicitly mentioned object that cannot be found. 

If you take look at the Details portion of your actual error message, it will include a reference to what it is that cannot be found. For my example posted above, Power Query is trying to get data from a table which is stated to exist in a record for which the Name field is supposed to equal "Bugs - Today".

If you'd like further assistance, please reply with a copy of your query/script, and screenshots of the error message and what is displayed in the preview in the step before the error is thrown.