The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
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-des...
And what is the connection type?
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-des...
Thank you NandanHegde. I will investigate other offerings.
Hi,
This is a screenshot of my sink settings