Data flow sink does not copies data as shown by data preview

Obaid UrRehman 166 Reputation points


I have a data flow sink that writes data to an inline dataset and creates file on blob.

The dataflow goes through many transformations and I have the desired output in the end before sink.

Here is how the output looks in sink data preview:

but when I download the data from azure blob to local system and open it in excel, it is all messed up and looks like this:

It seems that the data in not in order as shown in the data preview

Here is the setting of the sink:

Appreciate your help! Thanks :)

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,692 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nasreen Akter 10,761 Reputation points

    Hi @Obaid UrRehman , in the DataFlow, please do 'SORT' before 'SINK'. Thanks!

0 additional answers

Sort by: Most helpful