I'm encountering data truncation in my Databricks dashboards. I'm working with a large dataset, and the dashboard only displays a limited number of (truncated) rows.
let's take a dataset containing 1 million sales records. The dashboard currently only displays a limited number of rows, which affects the accuracy of important metrics such as total sales. Is there a way to configure the dashboards to handle larger datasets and ensure that they display the complete picture, including all 1 million records in visualizations?