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

George Rustean 20 Reputation points
2024-06-18T15:20:10.2733333+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,127 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,249 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
26 questions
0 comments No comments
{count} votes

Accepted answer
  1. phemanth 8,560 Reputation points Microsoft Vendor
    2024-06-19T05:00:31.04+00:00

    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 User's image

    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.

    2 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Nandan Hegde 31,346 Reputation points MVP
    2024-06-19T07:30:57.8366667+00:00

    Hey,

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

    User's image

    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

    0 comments No comments