Context

When working with dashboard widgets that query large datasets, you may encounter the following error message: "result has been truncated to the default limit of 10,000 rows". This typically occurs when the data being visualized in a widget exceeds 10,000 rows, causing the widget to display incomplete data.

Answer

The 10,000-row limit on dashboard widgets is a fixed limitation and cannot be expanded or bypassed. This restriction is in place to prevent performance issues within the dashboard.

If you need to work with datasets that exceed 10,000 rows, the recommended approach is to use data exports instead. Data exports do not have this row limitation and allow you to access and analyze your full dataset.

For more information on how to export and share data, please refer to the Adverity documentation on sharing and distributing dashboards.