Welcome to Microsoft Q&A forum and thanks for posting your query.
As a workaround you can use a Binary Dataset both on source and sink side and use HTTP linked service in the source dataset and point to your endpoint. Then download the file your sink using a Binary dataset on the sink side. Then use excel connector to transform your data and load to desired sink.
When using Binary dataset in copy activity, you can only copy from Binary dataset to Binary dataset. When using Binary dataset, the service does not parse file content but treat it as-is. For more info regarding Binary format please refer to this doc: Binary format in Azure Data Factory and Synapse Analytics
Hope this info helps. Do let us know how it goes.
- Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators