topic Re: How can we move the excel file from adls to share point in Data Engineering

How can we move the excel file from adls to share point

databicky — Sun, 08 Jan 2023 10:52:29 GMT

I have one excel file in the adls, i want to move that file into sharepoint, but i tried this method in data factory, but in sink sharepoint is not available, is there any possible way to do this?

Re: How can we move the excel file from adls to share point

Chaitanya_Raju — Sun, 08 Jan 2023 11:08:35 GMT

@Mohammed sadamusean Can you please help us with more details? like you want to perform the task with adf or databricks?

Re: How can we move the excel file from adls to share point

databicky — Sun, 08 Jan 2023 11:10:51 GMT

databricks is the first preference but any of them is ok for me

Re: How can we move the excel file from adls to share point

Chaitanya_Raju — Sun, 08 Jan 2023 11:31:05 GMT

Okay, by any chance have you tried logic apps? I tried using logic apps sometime in the past worked fine, or it has to be solved using only adf or databricks?

Re: How can we move the excel file from adls to share point

databicky — Sun, 08 Jan 2023 12:05:10 GMT

adf and databricks is the priority, i don't have much info on logic apps

Re: How can we move the excel file from adls to share point

KVNARK — Sun, 08 Jan 2023 14:32:48 GMT

@Ratna Chaitanya Raju Bandaru - Please refer to the below link if you can implement the same to sink side as sharepoint as its the other way round from the below link (source is sharepoint)

https://learn.microsoft.com/en-gb/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online

Re: How can we move the excel file from adls to share point

daniel_sahal — Mon, 09 Jan 2023 07:57:46 GMT

If you want to upload raw Excel file (not Sharepoint List) then IMO it would be easier to simply mount the Sharepoint Site as a network drive (https://support.microsoft.com/en-us/office/map-a-network-drive-to-a-sharepoint-library-751148de-f579-42f9-bc8c-fcd80ccf0f53) and copy the file.

All achievable through python script.