Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
ADF & PowerQuery Activity: Could not load resource '18895_PQ_customers'. Please ensure no mistakes in the JSON and that referenced resources exist. Status: UnknownError, Possible reason: Error: Unable to parse: 18895_PQ_customers
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 97%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
javier
936
Reputation points
Hi I am not sure why I am getting this error. When building the power query everything seems to work as expected, but when I close my browser tab and revisit ADF I get this error.
Also tried to rebuild the query from scratch and when trying to Debug it, I got an execution error: "extraneous input '18895' expecting..."
Any idea what is going on?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 63%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
svijay-MSFT 5,226 Reputation points Microsoft Employee2021-08-26T13:34:38.943+00:00 Hello @javier
From the error - It looks like the dataset has been changed or referenced incorrectly. Can you please confirm whether you are able to see the dataset with the name "18895_customers_PQ" at your end. It should be present under the dataset section like below.
-
svijay-MSFT 5,226 Reputation points Microsoft Employee
2021-09-02T11:46:06.447+00:00 @javier - Just checking in if you have had a chance to see the previous response. We need the information to understand/investigate this issue further.
Sign in to comment