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

Anonymous — Mon, 11 Nov 2024 09:59:51 GMT

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-factory#copy-file-from-sharepoint-online

how to achieve via copy activity component in Fabric Data Factory

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

Anonymous — Tue, 12 Nov 2024 01:37:53 GMT

Hi Anonymous

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.

Regards,

Nono Chen

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