Dashboard limits
This article describes the limits that apply to AI/BI dashboards, including pages, datasets, widgets, visualizations, and subscriptions.
Dashboard structure limits
The following limits apply to the overall structure and components of AI/BI dashboards:
Limit | Maximum value | Description |
---|---|---|
Pages per dashboard | 15 pages | A canvas can contain up to fifteen pages. New dashboards start with a single page. |
Datasets per dashboard | 100 datasets | You can define up to 100 datasets per dashboard. Datasets can be created from SQL queries, Unity Catalog tables or views, or uploaded files. |
Widgets per dashboard | 100 widgets | Dashboards can hold up to 100 widgets across all pages. Widgets include visualizations, filters, text boxes, and images. |
These limits apply to new AI/BI dashboards. When cloning legacy dashboards to AI/BI dashboards, the Clone to AI/BI dashboard feature supports legacy dashboards with a maximum of 100 widgets.
Visualization rendering limits
The following limits apply to how much data can be rendered in dashboard visualizations:
Visualization type | Maximum rows | Notes |
---|---|---|
Most visualizations | 10,000 rows | To optimize performance, most charts can only render 10K rows on the canvas. Otherwise, visualizations can be truncated. This applies to area, bar, line, scatter, pie, heatmap, and other chart visualizations. |
Table visualizations | 100,000 rows | Tables can display up to 100K rows before truncation. |
These row limits apply to the rendering of visualizations on the canvas. For information about dataset size thresholds and performance optimizations, see Dataset performance thresholds.
Dataset performance thresholds
While there's no hard limit on dataset size, Databricks applies different performance optimizations based on dataset result size:
Dataset size | Optimization behavior |
---|---|
Small datasets (≤ 100,000 rows or ≤ 100MB) | The dataset result is pulled to the client, and visualization-specific filtering and aggregation are performed in the browser. Only the dataset query appears in the query history. |
Large datasets (> 100,000 rows or > 100MB) | The dataset query text is wrapped in a SQL |
For optimal dashboard performance, keep your datasets small by using explicit column selection, WHERE
clauses, and parameters to scope your SQL queries. See Dataset optimization and caching.
Dashboard subscription limits
Dashboard subscription emails include base64 encoded files with the following size limits:
File type | Maximum combined size | Behavior when limit exceeded |
---|---|---|
PDF + DesktopImage | 9MB combined | See below for specific behaviors based on which file exceeds the limit. |
Subscription size limit behavior
The following describes the expected behavior when the combined file size exceeds the 9MB limit:
- If the PDF file is greater than 9MB: The subscription email doesn't include the PDF attachment or any images. It includes a note that says the dashboard has exceeded the size limit and shows the actual file size of the current dashboard.
- If the combined file size is greater than 9MB: Only the PDF is attached to the email. The inline message includes a link to the dashboard but no image.
For more information about dashboard subscriptions, see Manage scheduled dashboard updates and subscriptions.