Limits in DataLens On-premises

Limits are technical constraints of the DataLens architecture. Limits cannot be changed.

General limits

Note

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

Type of limit Value
Maximum number of tables per dataset 32
Maximum number of fields per dataset 1,200
Maximum data size for direct chart export 50 MB

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 set 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 filters:

Chart type Limit
Charts
Line chart 75,000 rows
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 chart 75,000 rows
Pie chart 1,000 rows
Tree chart 1,000 rows
Tables
Table 100,000 rows
Pivot table 100,000 cells
Pivot table 800 columns