topic Re: Trying to use a Sharepoint folder as Destination in CopyData activity in Pipelines

Trying to use a Sharepoint folder as Destination in CopyData activity

GeorgeR_2024 — Wed, 19 Jun 2024 08:58:15 GMT

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&CID=51325cbe-8ffc-43d0-8aa5-a62ab575d31f.

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

Can anybody help with this?

Re: Trying to use a Sharepoint folder as Destination in CopyData activity

NandanHegde — Wed, 19 Jun 2024 09:12:19 GMT

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

Re: Trying to use a Sharepoint folder as Destination in CopyData activity

GeorgeR_2024 — Wed, 19 Jun 2024 13:03:45 GMT

Hi,

This is a screenshot of my sink settings

Re: Trying to use a Sharepoint folder as Destination in CopyData activity

NandanHegde — Wed, 19 Jun 2024 13:28:42 GMT

And what is the connection type?

Re: Trying to use a Sharepoint folder as Destination in CopyData activity

GeorgeR_2024 — Tue, 25 Jun 2024 08:39:45 GMT

Thank you NandanHegde. I will investigate other offerings.