Copy data from Folder

Hi amymc ,

Thanks for the reply from AndyDDC , his answer works like a charm!

Your problem should be in the gateway.

I used pipeline for copy data to lakehouse and it worked, here are my test steps:

First, select Folder for the Get Data method, then configure it, note that you must have a gateway (because the folder is local) and the gateway must be running, select the appropriate authentication method.

Just choose a lakehouse as your destination.

Then you can click on the Validate and if there are no problems you can Run it.

After running successfully, the effect is as shown below:

You mentioned that you were able to access data from dataflow gen2 without a local data gateway, I'm a bit confused because when I test it if I want to access the local data it reminds me to configure the gateway, like in the picture below:

I would like to know how you are able to access the local Folder without a gateway?

Please configure the gateway and run it and then try again to connect to the local folder using pipeline.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!