How to give a Sharepoint folder as a destination in Microsoft Fabric CopyData activity

Question

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,'

Answer 1

Hi @George Rustean

Thanks for the question and using MS Q&A platform.

Microsoft Fabric is currently not supported in the Q&A forums, the supported products are listed over here https://docs.microsoft.com/en-us/answers/products (more to be added later on).

Can you please open as a new thread in MS Fabric community: https://community.fabric.microsoft.com/t5/General-Discussion/bd-p/ac_generaldiscussion

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Hey,

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