Cannot create connection in Azure Data Factory due to access issue

Question

I was given Owner access of an Azure data factory resource. I have to copy a csv from Blob Storage to Azure Table. While creating a copy data pipeline, I cannot create a connection to that csv file. A similar pipeline was successfully working in my free subscription. I also have owner access of the Blob Storage. Even when I press test connection, it returns "connection successful"

The error that I get is: The client with object id does not have authorization to perform action 'Microsoft.Resources/deployments/write' over scope .

I have added in place of different ids in the error message.

Answer 1

The fact that the error says Write, makes me think that the issue is maybe with the Azure Table resource's permissions. These kind of errors are easy to troubleshoot now, because in the graphical interface you can click the Check Connection button.

Try going to the dataset you've created for this csv file, and click on Preview Data. If it shows data, then the problem is not in the connection to the csv file, and most likely it is with Azure Table.

Hope this helped!

Answer 2

It was a problem with the roles. To create child objects in Data Factory web tool, one needs the "Data Factory Contributor" role for the whole resource group, not just for the resource itself.