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

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")

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

Nandan Hegde 29,886 Reputation points MVP

2022-11-07T14:37:42.31+00:00

what authentication is being used to access database and what is the security access of it within db
Martijn Copier (Admin) 6 Reputation points

2022-11-07T15:42:26.76+00:00

We are using a Service Principle to access the DB, this seems to connect just fine.
It should be listed as "Databse Owner" but i am not 100% sure about this
Martijn Copier (Admin) 6 Reputation points

2022-11-08T08:20:28.293+00:00

Do you have any suggestions? :)
Mike Matthews 1 Reputation point

2023-03-21T11:24:10.48+00:00

Did you solve this? Our Data Factory is suddenly displaying the same behaviour today.