Cloudera Docs

Changing the number of rows downloaded as CSV or Excel files

You can control the number of rows included in CSV/Excel exports and Detailed Data views for an individual visual by using the Number of rows downloaded during CSV/Excel export and Detailed Data option.

Default behavior

By default, the number of rows included in a CSV/Excel export or Detailed Data view is determined as follows:

  • The Maximum number of rows to fetch option defines the default row limit.

  • For table visuals only:

    • If a value is specified on the Limit shelf, that value takes precedence.
    • If the Limit shelf is empty, the Maximum number of rows to fetch value is used.

Overriding the default row limit

To specify a custom row limit:

  1. Open the visual in Edit mode.
  2. Open Settings > Data.
  3. Enter a value in the Number of rows downloaded during CSV/Excel export and Detailed Data field.

This setting overrides the Maximum number of rows to fetch option. For table visuals, it also overrides any value specified on the Limit shelf.

The configured value applies only to CSV/Excel exports and the Detailed Data view. It does not affect how many rows are displayed in the visual or visible in Powerpoint , PDF, or PNG downloads.

Leave the field empty to use the default row limits defined by the visual configuration and system settings. To export a specific number of rows, enter a positive integer (for example, 6000).