Connection Between Data Factory and Azure SQL is not able to import schema of table. results in "Missing required property 'type' on entity reference" error

Martijn Copier (Admin) 6 Reputation points
2022-11-07T14:00:55.217+00:00

We have set up a connection between our Data Factory and our Azure SQL databse.

When trying to import the schema of a table from the Database, into Data Factory, we get the following error message.
(we do this by creating a new dataset in Dat Factory, and clicking "Preview Data")257859-chrome-yujem6yexj.png

Error code
MissingRequiredProperty
Details
Missing required property 'type' on entity reference Activity ID: ....

We have found very little information on how to solve this error

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,879 questions
{count} vote