Data Factory New Linked Service Connection Failure Acl And Firewall Rule

I'm trying to move data from a datalake stored in Azure Data Lake Storage Gen1 to a table in an Azure SQL database. In Data Factory 'new Linked Service' when I test the connection

Solution 1:

Please follow me:

First:

Go to ADF and new Linked service in ADF,then copy Managed identity object ID.

Second:Go to Azure Data Lake Storage Gen1,navigate to Data Explorer -> Access -> click select in the 'Select User or group' field.

Finally:paste your Managed identity object ID and then test your connection in ADF.