Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
olliehernandez
New Member

Queries blocked by error

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?

1 ACCEPTED SOLUTION
jennratten
Super User
Super User

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]

jennratten_1-1717149480067.png

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. 

jennratten_2-1717150190956.png

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.

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

View solution in original post

1 REPLY 1
jennratten
Super User
Super User

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]

jennratten_1-1717149480067.png

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. 

jennratten_2-1717150190956.png

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.

If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.

Proud to be a Microsoft Fabric Super User

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors