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

Obaid UrRehman 166 Reputation points
2022-03-24T22:06:23.293+00:00

Hi,

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:

186671-datapreview.png
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:
186681-sinkerror.png

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

Here is the setting of the sink:
186731-sink1.png

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
    2022-03-25T00:48:38.74+00:00

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


0 additional answers

Sort by: Most helpful