how to implement copy activity for copy files from SharePoint to lake house

[smurugan]

i need to copy files from sharepoint to lakehouse i followed the Azure Data Factory blog ,but its not same for fabric

https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-fact...

how to achieve via copy activity component in Fabric Data Factory

[Anonymous · Accepted solution]

Hi @smurugan 

If you need to copy SharePoint files to lakehouse, here are some things I want to share with you:

First, you need to register an application on the Microsoft Identity platform to connect to SharePoint using service principal authentication.

Make sure your application has permission to access the SharePoint Online list.

Create a new data pipeline and add a Copy Activity to the pipeline.

In Source, select SharePoint Online List as the data source. Select the SharePoint connection you created earlier.

In Destination, select your target data store, such as Lakehouse.

Set up your SharePoint Online List connection - Microsoft Fabric | Microsoft Learn

Configure SharePoint Online List in a copy activity - Microsoft Fabric | Microsoft Learn

copy-activity-destination

Regards,

Nono Chen

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