I have a question about transforming data in Azure Data Factory Studio. How to import the csv file in container in blob to the data flow?

Question

I have a question about transforming data in Azure Data Factory Studio. How to import the csv file in container in blob to the data flow?

jaso223 0

I am a first time user of Azure Data Factory Studio. I wanted to use my csv file which is in a blob in the Data Factory, the linked service that I am using is Azure Data Lake Storage Gen 2. I am getting the following error. What should I do?

User's image

KranthiPakala-MSFT 39,327 Reputation points Microsoft Employee

2023-05-05T23:29:16.3266667+00:00

@jaso223 Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 39,327 Reputation points Microsoft Employee

2023-05-09T16:51:51.0266667+00:00

@jaso223 We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

KranthiPakala-MSFT 39,327 Reputation points Microsoft Employee

2023-05-05T23:29:16.3266667+00:00

@jaso223 Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 39,327 Reputation points Microsoft Employee

2023-05-09T16:51:51.0266667+00:00

@jaso223 We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

Hi @jaso223 ,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

By looking at the error message my understanding is that you may have used either service principal or managed identity authentication in your Azure blob storage account liked service. Please correct if I'm wrong.

Ref doc: ADF mapping data flow - User-assigned managed identity authentication
User's image

If your blob account enables soft delete, system-assigned/user-assigned managed identity authentication is not supported in Data Flow.

Ref doc: Error code: DF-Blob-FunctionNotSupport

Azure Blob Storage events, soft delete or automatic snapshot is not supported in data flows if the Azure Blob Storage linked service is created with service principal or managed identity authentication.

Solution: Hence to overcome the issue, disable Azure Blob Storage events, soft delete or automatic snapshot feature on the Azure Blob account, or use account key authentication to create the linked service.

Below is how you can disable soft deletes.

Hope this info helps.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

I have a question about transforming data in Azure Data Factory Studio. How to import the csv file in container in blob to the data flow?

1 answer

Activity