Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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?
Solved! Go to 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.
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
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.