topic Using a file uploaded manually in a workspace as a souce for a copy activity in Pipelines

Using a file uploaded manually in a workspace as a souce for a copy activity

pmscorca — Mon, 01 Jul 2024 07:48:39 GMT

Hi,

I've uploaded manually a file in a Fabric workspace and I need to use it as a source in a copy activity.

How could I find this file as a source of the copy activity? Thanks

Re: Using a file uploaded manually in a workspace as a souce for a copy activity

NandanHegde — Mon, 01 Jul 2024 08:21:22 GMT

Can you please specify what you mean by uploaded the file in workspace? Was it uploaded in files section in lakehouse?

Re: Using a file uploaded manually in a workspace as a souce for a copy activity

pmscorca — Mon, 01 Jul 2024 10:15:25 GMT

Hi, using this feature

Re: Using a file uploaded manually in a workspace as a souce for a copy activity

Anonymous — Tue, 02 Jul 2024 06:19:27 GMT

Hi pmscorca

NandanHegde Thank you very much for your prompt reply, please allow me to share some content here.

Files that you can manually upload in the Fabric workspace can be used as sources in the copy activity.

In the source configuration of the replication activity, select Workspace as the data store type.

From the workspace, select the data warehouse where you are uploading the files.

In the source file configuration, select "File Path" and specify the path where you upload the file.

You can view the link below for more details:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn

Configure Data Warehouse in copy activity in Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Regards,

Nono Chen

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

Re: Using a file uploaded manually in a workspace as a souce for a copy activity

pmscorca — Tue, 02 Jul 2024 15:52:23 GMT

Hi,

I don't see any data store type option in the source tab of a copy activity:

Re: Using a file uploaded manually in a workspace as a souce for a copy activity

frithjof_v — Tue, 02 Jul 2024 18:30:35 GMT

I think you need to upload the file to the Files section of a Lakehouse. https://learn.microsoft.com/en-us/fabric/data-engineering/load-data-lakehouse#local-file-upload

(ref. also https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/01-lakehouse.html#upload-a-file)

The screenshot you show in a previous reply (Upload, OneDrive, SharePoint, Browse) has a text under it (not displayed in the screenshot) "Upload a .pbix or .rdl file to your workspace".

Unless you want to upload a .pbix file or .rdl file, I think the suitable place to upload the file is in a Lakehouse Files directory.

Then, in the source pane of the Copy activity in Data pipeline, I think you can select the Lakehouse connection, and select Files in the Root folder radio button, in order to find the file and use it as source for the copy data activity.

Re: Using a file uploaded manually in a workspace as a souce for a copy activity

pmscorca — Tue, 02 Jul 2024 20:31:17 GMT

Hi, I've already used a Lakehouse files directory to upload a source file.

I know that the upload interface that I've shown is an old one, if my info is correct.

Thanks

Re: Using a file uploaded manually in a workspace as a souce for a copy activity

Anonymous — Thu, 11 Jul 2024 09:22:27 GMT

Hi pmscorca

Can you tell me if your problem is solved? If yes, please accept it as solution.

Regards,

Nono Chen