Dataflow debug only shows 100 rows even if the query returns >100 records. Row limit is set to 1000.

Question

Dataflow debug only shows 100 rows in the web UI in tabular format even if the query returns >100 records. Row limit is set to 1000. Is this the default behavior in azure synapse analytics?

I know this is a display only behavior as I am able to join and get the results from records that are not included in the 100 rows displayed.

Is there a way to view the entire result returned by the query in the datapreview window ,given row limit < records in result set.

Answer 1

Hi @Nandu S Raj ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

As per my understanding you are trying to understand why the dataflow data preview is showing upto 100 records when the row limit is set to 1000.

The Row Limit setting in the Data Flow debug configuration only controls the maximum number of rows fetched for processing. It controls the rows being read.

However, the display limit of 100 rows is independent of the row limit setting and is specifically for the UI in the Data Preview tab. It's by default set to 100 and can't be changed. It controls the rows that you see.

Additionally, there's an export button on the top of the data preview panel that you can use to export the preview data to a CSV file for offline data exploration. You can use this feature to export up to 1,000 rows of preview data.

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou