Trying to use a Sharepoint folder as Destination in CopyData activity

[GeorgeR_2024]

In Microsoft Fabric, I am trying to setup a Copy Data activity that executes a stored procedure from Azure SQL Database and outputs a csv file to a Sharepoint Folder. I have copied the link from the sharepoint folder into the Connection field. The Test connection comes up 'Connection successful', however when I run the activity it fails with the following error:

Failure happened on 'destination' side. ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 403 Forbidden, please check your activity settings.

Request URL: https://xxx.sharepoint.com/sites/SFDataExtract/Shared%20Documents/George%20Test?csf=1&web=1&e=gziJM5....

Response: 403 FORBIDDEN,Source=Microsoft.DataTransfer.ClientLibrary,'

Can anybody help with this?

[NandanHegde]

And what is the connection type? 

[NandanHegde · Accepted solution]

can you please specify /share an image of your copy activity sink settings.

Based on my understanding; Similar to ADF, even fabric data pipeline doesnt support sharepoint as a sink.

In case if you need to copy file within sharepoint folder, you would have to use logic app or other offerings to do the same

similar thread : https://learn.microsoft.com/en-us/answers/questions/1701561/how-to-give-a-sharepoint-folder-as-a-des...

[GeorgeR_2024]

Thank you NandanHegde. I will investigate other offerings.

[GeorgeR_2024]

Hi, 

This is a screenshot of my sink settings