0

I am relatively new to Azure Analytics area.

I am getting following error while ingesting data in Azure Synapse using pipeline mentioned in this exercise.

However, at the end, when I try to deploy the data ingestion pipeline, it gives me following error.

BadRequest The document creation or update failed because of invalid reference 'adventureworks'

enter image description here

I tried removing the space between the connection name (which it had earlier). Tried changing the name, which I thought might be taking from somewhere else. But, still it gives ERROR. I can also access products.csv when tried accessing directly.

Is there any other way I can troubleshoot this problem? Or is this documentation missing any important step or something changed after this doc and its not updated accordingly?

Pallavi
  • 548
  • 2
  • 9
  • 18
  • 1
    Please check this thread which provides a solution for similar problem: https://stackoverflow.com/questions/72416798/the-document-creation-or-update-failed-because-of-invalid-reference – Saideep Arikontham May 30 '22 at 08:16

1 Answers1

0
  • As per the Microsoft documentation, try to change the step 6 & 9 from Ingest data -> 6th point Row delimiter as Default (\r,\n, or \r\n) from the above.
  • As we implemented and followed the same steps and here it is a working solution for the similar SO.
  • And as per @ChiragMishra's reply here, maybe you have not published the linked service once you created, recheck it after connection modified (space removed) have you hit the publish.
Ryan M
  • 18,333
  • 31
  • 67
  • 74
RajkumarPalnati
  • 541
  • 2
  • 6