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

Nandu S Raj 40 Reputation points
2024-11-14T15:57:56.0666667+00:00

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.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,031 questions
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 33,636 Reputation points Microsoft Employee
    2024-11-15T08:55:26.1166667+00:00

    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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.