Hi Team,
We are using Azure DevOps for Datafactory deployments. In our process we are using copy activity with source type as CSV format of files and able to deploy all these pipelines and their related datasets successfully.
But right now our source file type is in form of Excel sheet and this is where we are getting an issue with the deployment. I have attached screenshots of the files that have check-in in our repository and after deploying the sourcetype is automatically converted from Excel to dataset(In dataset json file) and ExcelSource to CopySource(In pipeline json file).
Could someone suggest where we have done mistake or how it can be resolved.
Apologies if any mistakes in the question.