I am trying to to reverse the order of the rows. While data preview of Sink transformation, data is getting reversed. But while debug the data is not getting written as seen in sink transformation. There is no error.
Am I missing the setting part? Need you help to resolve the issue.
ADF dataflow configurations.

Output

