The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
17 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
21 | |
4 | |
3 | |
3 | |
3 |