Forum Discussion
Trying to use a Sharepoint folder as Destination in CopyData activity
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.
Response: 403 FORBIDDEN,Source=Microsoft.DataTransfer.ClientLibrary,'
Can anybody help with this?
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-destination-i
4 Replies
- NandanHegde
Super User
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-destination-i
Hi,
This is a screenshot of my sink settings
Thank you NandanHegde. I will investigate other offerings.
- NandanHegde
And what is the connection type?
