How to upload files into sharepoint using Azure synapse analytics

Question

How to upload files into sharepoint using Azure synapse analytics

Darbarbasha Nadigadda 0

How to upload files into sharepoint using Azure synapse analytics ?

Nandan Hegde 35,031 Reputation points MVP Moderator

2025-04-16T14:35:33.9066667+00:00

Unfortunately, Sharepoint is not supported as a sink in Synapse pipelines.

So you would have to integrate the pipeline with other sources like Logic apps, Azure functions, databricks etc.

You can use Synapse notebooks for coding way :

https://stackoverflow.com/questions/61603107/upload-a-file-to-a-sharepoint-folder-using-python
Smaran Thoomu 23,260 Reputation points Microsoft External Staff Moderator

2025-04-17T07:53:29.4466667+00:00

@Darbarbasha Nadigadda We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Nandan Hegde 35,031 Reputation points MVP Moderator

2025-04-16T14:35:33.9066667+00:00

Unfortunately, Sharepoint is not supported as a sink in Synapse pipelines.

So you would have to integrate the pipeline with other sources like Logic apps, Azure functions, databricks etc.

You can use Synapse notebooks for coding way :

https://stackoverflow.com/questions/61603107/upload-a-file-to-a-sharepoint-folder-using-python
Smaran Thoomu 23,260 Reputation points Microsoft External Staff Moderator

2025-04-17T07:53:29.4466667+00:00

@Darbarbasha Nadigadda We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

Hi @Darbarbasha Nadigadda

As per my understanding, you are looking to upload a file to SharePoint using Synapse Data Pipelines. Please feel free to correct me if my understanding is not accurate.

Currently, there is no out-of-the-box feature or connector in Synapse Pipelines to upload files directly to SharePoint.

As a workaround, you can either:

Create custom code (e.g., using PowerShell or Python) and execute it using a Custom Activity in Synapse Pipelines, or
Implement a solution using Azure Logic Apps, which has native connectors for SharePoint.

Here is a third-party article from a community contributor that outlines the steps involved: Publishing files from Synapse to SharePoint

User's image

Additionally, here is a related feature request submitted by other users: Support SharePoint folder as a sink. Support sharepoint folder as a sink

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful—it can assist other community members facing similar issues.

Share via

How to upload files into sharepoint using Azure synapse analytics

1 answer

Your answer