https://community.fabric.microsoft.com/t5/Pipelines/COPY-excel-files-into-Files-directory-in-a-lakehouse/m-p/4009420#M4191 <P>I want to create a Data Pipeline that allows me to COPY some excel files that I have in a Sharepoint directory to my /Files path in my lakehouse A_LH.</P><P>&nbsp;</P><P>How can I do it? With COPY activity there's the Sharepoint online list connector, but it's not useful to do this.</P> Tue, 25 Jun 2024 15:31:19 GMT amaaiia 2024-06-25T15:31:19Z https://community.fabric.microsoft.com/t5/Pipelines/COPY-excel-files-into-Files-directory-in-a-lakehouse/m-p/4009420#M4191 <P>I want to create a Data Pipeline that allows me to COPY some excel files that I have in a Sharepoint directory to my /Files path in my lakehouse A_LH.</P><P>&nbsp;</P><P>How can I do it? With COPY activity there's the Sharepoint online list connector, but it's not useful to do this.</P> Tue, 25 Jun 2024 15:31:19 GMT https://community.fabric.microsoft.com/t5/Pipelines/COPY-excel-files-into-Files-directory-in-a-lakehouse/m-p/4009420#M4191 amaaiia 2024-06-25T15:31:19Z https://community.fabric.microsoft.com/t5/Pipelines/COPY-excel-files-into-Files-directory-in-a-lakehouse/m-p/4009437#M4192 <P>You can use the web activity to get the files from sharepoint.</P> <P>The below blog porvides details to do the same :</P> <P><A href="https://www.syntera.ch/blog/2022/10/10/copy-files-from-sharepoint-to-blob-storage-using-azure-data-factory/" target="_blank">https://www.syntera.ch/blog/2022/10/10/copy-files-from-sharepoint-to-blob-storage-using-azure-data-factory/</A></P> <P>&nbsp;</P> <P>You need to replace the blob with the lakehouse</P> Tue, 25 Jun 2024 15:40:22 GMT https://community.fabric.microsoft.com/t5/Pipelines/COPY-excel-files-into-Files-directory-in-a-lakehouse/m-p/4009437#M4192 NandanHegde 2024-06-25T15:40:22Z