I am trying to load the data from Azure Synapse Link (dataverse CRM) to Azure Data Lake Gen2. If I loaded data first time debug mode, i can see the the CSV files with loaded data. Similar, i am trying to running again and again, the second time onwards, i can not see the data in CSV file. please advise while doing SINK activity in dataflow.
I made settings as below like, Sink activity i choose Clear the folder before loading every time.
