azure-synapsedata-ingestion

The document creation or update failed because of invalid reference


I am having trouble completing an excersice on the Microsoft Learn platform.

https://learn.microsoft.com/en-us/learn/modules/examine-components-of-modern-data-warehouse/5-exercise-azure-synapse

I have followed the instructions, but get the following error

Error message

Source settings

Does anyone know what's causing this, and how I can fix the issue?

Regards, Anders


Solution

  • I ran into this issue too. Unless I missed a step in the Explore Azure Synapse Analytics exercise (https://learn.microsoft.com/en-us/learn/modules/examine-components-of-modern-data-warehouse/5-exercise-azure-synapse), I found the issue to be that the source linked service was not being created for some reason in Steps 3 and 4. I suggest doing the following in a different tab, so you can come back to Ingest Data wizard later to pick up where you left off. I created the source linked service by going to my workspace, then clicking on the "Manage" icon (the one with the wrench on the briefcase). After that, click on "Linked services" followed by clicking on "+ New". At this point, a number of connection icon should appear. In the search bar type "HTTP" and click on it and click "continue". This will bring up a form that will be the same as the one you saw in step 3 of the Explore Azure Synapse Analytics exercise. Fill it out as directed in the exercise, and you should have a source linked service connection of Type "HTTP" created. Screenshot of Buttons to Click on to Create Source Linked Service

    As long as you've completed the rest of the steps of the exercise, going back to the Deployment step and proceeding should now allow it successfully complete.