Lakehouse File to onPrem Folder

[joanfatz]

I created a process to create a .csv file under Files in the Lakehouse.  This will be a daily process with a filename of 'filename_yyyymmdd.csv'

Then I use Copy data to move the file to an onPrem file folder, but it just move the empty .csv file 

The actual data ends up in a file named 'part-000000-'  under the 'Filename.csv' folder in the Lakehouse.

What is the best way to move this data to an onprem filesystem? 

[v-yilong-msft · Accepted solution]

Hi @joanfatz ,

I create a pipeline and I think you can connect folder.

If you want to learn more, you can watch this video: Microsoft Fabric: How to Transfer Data from Fabric Lakehouse to Local System: Step-by-Step Tutorial ...

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.