Limits in DataLens

Limits are technical limitations due to DataLens architectural features. The limits cannot be changed.

General limits


DataLens has no limitation on the amount of data on the source you are connecting to.

Type of limitValue
Maximum number of tables in a single dataset32
Maximum number of fields in a single dataset1,200

Chart data limits

Charts in DataLens can only display a limited amount of data. If the number of rows (columns and cells for pivot tables) in a dataset exceeds the established limit, the chart will not be built. Therefore, to build a chart from data in a large dataset, select a part of the data to display based on the limits below using the filters:

Chart typeLimit
Line chart75,000 rows
Stacked area chart
Normalized area chart
75,000 rows
Column chart
Normalized column chart
75,000 rows
Bar chart
Normalized bar chart
75,000 rows
Scatter chart75,000 rows
Pie chart1,000 rows
Tree chart1,000 rows
Table100,000 rows
Pivot table100,000 cells
Pivot table800 columns