Troubleshooting Data Retrieval Errors in Widgets Due to Deleted Columns in Connected Tables

When a widget on a dashboard is configured to use an expression column that references a field, and that field is subsequently deleted from the database, it can result in a data retrieval error. This is particularly common with live mode SQL data source connections. To address this issue, follow the steps outlined below:

Steps to Resolve the Issue

1. Navigate to the dashboard that contains the widget experiencing the error.
   
   
   
   
   
2. Enter the edit mode for the dashboard and access the data source configuration for the affected widget.
3. Click on the Run button to refresh and load the most recent data from the data source.
   
4. The expression column that references the deleted field will be identified and removed automatically from the expression designer.
5. Save the changes to the data source configuration. This action will ensure that the deleted column is also removed from the widget’s configuration.
   
   
6. After saving, the widget should now render correctly using the remaining available columns, without encountering any data retrieval errors.
   
   

By following these steps, you can quickly rectify issues caused by changes in the underlying database structure that affect your dashboard widgets.