Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Naman_
New Contributor

Loading multiple files from local to lakehouse

I used a gateway to connect to my local and if I try to access single file I willl able to load the file, but if I try to load a multiple files using foreach loop  I am getting an error, Could Anyone help me with this?

Naman__0-1734692861484.png

 

 

1 ACCEPTED SOLUTION
v-hashadapu
Honored Contributor II

Hi @Naman_ ,Thank you for reaching out to Microsoft Fabric Community Forum.

 

Based on the error message, it appears that there is an issue with how the Copy data1 action is referenced within your ForEach loop.

Check the Action Placement in the ForEach Loop by Ensuring that the Copy data1 action is correctly placed within the ForEach loop and that it follows the correct runAfter or Trigger path.

Modify the Pipeline Configuration, it is needed to make sure that the Copy data1 action is appropriately linked in the workflow.

For example:

{

  "type": "ForEach",

  "name": "ForEachFile",

  "activities": [

    {

      "type": "Copy",

      "name": "Copy data1",

      "inputs": [

        {

          "type": "DatasetReference",

          "referenceName": "InputDataset"

        }

      ],

      "outputs": [

        {

          "type": "DatasetReference",

          "referenceName": "OutputDataset"

        }

      ],

      "runAfter": {

        "PreviousActivity": [

          "Succeeded"

        ]

      }

    }

  ]

}

If this helps, please mark it ‘Accept as Solution’, so others with similar queries may find it more easily. If not, please share the details.

View solution in original post

1 REPLY 1
v-hashadapu
Honored Contributor II

Hi @Naman_ ,Thank you for reaching out to Microsoft Fabric Community Forum.

 

Based on the error message, it appears that there is an issue with how the Copy data1 action is referenced within your ForEach loop.

Check the Action Placement in the ForEach Loop by Ensuring that the Copy data1 action is correctly placed within the ForEach loop and that it follows the correct runAfter or Trigger path.

Modify the Pipeline Configuration, it is needed to make sure that the Copy data1 action is appropriately linked in the workflow.

For example:

{

  "type": "ForEach",

  "name": "ForEachFile",

  "activities": [

    {

      "type": "Copy",

      "name": "Copy data1",

      "inputs": [

        {

          "type": "DatasetReference",

          "referenceName": "InputDataset"

        }

      ],

      "outputs": [

        {

          "type": "DatasetReference",

          "referenceName": "OutputDataset"

        }

      ],

      "runAfter": {

        "PreviousActivity": [

          "Succeeded"

        ]

      }

    }

  ]

}

If this helps, please mark it ‘Accept as Solution’, so others with similar queries may find it more easily. If not, please share the details.

Helpful resources

Announcements
Users online (25)