Loading multiple files from local to lakehouse

[Naman_]

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?

 

[v-hashadapu · Accepted solution]

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.