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 Reputation points
2023-05-04T06:48:44.39+00:00

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

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,418 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,074 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2023-05-04T15:26:01.88+00:00

    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. User's image

    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.

    0 comments No comments