azureazure-data-factoryazure-data-lake-gen2

Error when I am trying to connect between Azure Data factory and Azure Data lake Gen2


Hello Azure Data factory experts, I have this error I am trying to connect from Azure data factory to Data lake Gen2 by creating Linked services in Azure data factory, but I got this error. How can anyone help?

BR, Mohammed

ADLS Gen2 operation failed for: Storage operation '' on container 'XXXXXXXXXX' get failed with 'Operation returned an invalid status code 'Forbidden''. Possible root causes: (1). It's possible because the service principal or managed identity don't have enough permission to access the data. (2). It's possible because some IP address ranges of Azure Data Factory are not allowed by your Azure Storage firewall settings. Azure Data Factory IP ranges please refer https://learn.microsoft.com/en-us/azure/data-factory/azure-integration-runtime-ip-addresses.. Account: 'azurestoragforalltype'. ErrorCode: 'AuthorizationPermissionMismatch'. Message: 'This request is not authorized to perform this operation using this permission.'. RequestId: '83628e11-d01f-0020-33c3-cc8430000000'. TimeStamp: 'Fri, 29 Oct 2021 12:49:39 GMT'.. Operation returned an invalid status code 'Forbidden' Activity ID: ef66fc97-6bbb-4d4e-99fb-95c0ba3a4c31.


Solution

  • Hi you should assign yourself at least contributor access to the lake and then try connect to the lake using managed identity from adf, this should solve your problem enter image description here