Linked Service with ADF Connection Failing

Question

I am attempting to connect by Azure Data Lake Analytics account with Azure Data Factory via a Linked Service. I have added the required information in the Edit linked service blade, created an app and a secret for the Service Principal ID and key, set up the API permissions, added the role assignment of Data Lake Analytics Developer to the credentials I am using, and used the Add User Wizard to give the credentials I am using the Data Lake Analytics Developer role and assign read and write permissions. When I test the connection in my linked service I get the message: "User is not authorized to data lake analytics."

These are the two tutorials I followed to create this linked service:
https://pedrosancheznaranjo.com/conectando-azure-datalake-analytics-a-azure-datafactory-con-un-linked-service-y-service-principal
https://www.mssqltips.com/sqlservertip/5930/create-azure-data-lake-linked-service-using-azure-data-factory/

I cannot find any information on what I may have done incorrectly to get the error message "User is not authorized to data lake analytics."

Answer 1

@Supply Chain Glass You need to add role assignment of Data Lake Analytics Developer to you registered application/service principal instead of user credentials you are using. While adding the role assignment you can search your application on Select search box and then select your application (See screenshot below).

Once added you can validate your connection by going to your ADF instance. (See screenshot below)

Please let me know if you still see any issues.

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.