ADF Data Flows reads only 1 record from Json file instead of all

Krishnamohan Nadimpalli 401 Reputation points
2023-04-19T08:41:09.2666667+00:00

Hi I have data in following Json format. I am using ADF Data flow to convert this into csv file. User's image

I created JSON dataset to read this file and the following is the projection created User's image

Following are the JSON Settings in Source Options User's image

Now when I preview the dataset , I get only one row instead of multiple rows. Ideally it has more than 10k rows in Json. I tried with Array of Documents in Source options but not working. User's image

Following is the python implementation which is working fine. Json data is available in "data" and able to parse data into "df1" User's image

What changes I need to make to show full data or 1000 rows of data in data preview?

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