Azure Data Factory - Azure Data Lake Gen1 access

0
votes

A file is being added by the Logic Apps to the Data Factory V2 I have a Data Factory that access 'data lake gen 1' to process the file. I receive the following error, when I try to debug the data factory after file is added.

 "ErrorCode=FileForbidden,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to read a 'AzureDataLakeStore' file. File path: 'Stem/Benchmark/DB_0_Measures_1_05052020 - Copy - Copy - rounded, date changed - Copy (3).csv'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (403) Forbidden.,Source=System,'",

When I "Apply to children" after next load permission, error is gone. Tried so far: - Assigned permission in Data Lake for the Data Factory and it`s children.

  • Assigned permission in Data Lake Folder for the Data Factory and it's children.
  • Added data factory as a contributor to data lake.
  • Added data factory as an owner to data lake.
  • Allowed "all Azure services to access this Data Lake Storage Gen1 account".

After all tries, still need manually to "apply permission to children" for each file added.

Is there anyway to fix this?

2
azureazure-data-factoryazure-data-lake

2 Answers

0
votes

Can reproduce your error:

enter image description here

This is how I resolve:

enter image description here

enter image description here

enter image description here

enter image description here

And my account is the owner of the data lake gen1. The datafactory is the contributor of the data lake gen1.

enter image description here

0
votes

you need to give Read + Execute Access on parent folders and then do what @Bowman Zhu mentioned above.