Forum Discussion
Queries blocked by error
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.
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.