Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
GeorgeR_2024
New Member

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.

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?

1 ACCEPTED SOLUTION
NandanHegde
Super User
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

 

NandanHegde_0-1718788302762.png

 

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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

4 REPLIES 4
NandanHegde
Super User
Super User

And what is the connection type? 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
NandanHegde
Super User
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

 

NandanHegde_0-1718788302762.png

 

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




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Thank you NandanHegde. I will investigate other offerings.

Hi, 

This is a screenshot of my sink settings

GeorgeR_2024_0-1718802202776.png

 

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors