- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-06-2022 08:42 PM
We have scheduled a dashboard to automatically refresh at some specific time.
However, some visualizations in the dashboard don't get refreshed at the scheduled time.
Checking the query logs, we found the source queries were properly executed, but the visualization didn't get updated.
Anyone knows how to resolve this issue?
- Labels:
-
Databricks SQL Dashboard
-
SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2022 12:21 PM
Hi @noi metaaphanon Are you following the correct approach to refresh the dashboard? If yes, are you making any changes to the dashboard parameters and expecting the dashboard visualization to update at refreshes?
The value that dashboard refresh uses is the default value of the parameter saved by the first query in the dashboard that uses it. Try setting the default value in the query and see if the visualizations are updating.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2022 06:35 PM
Thank you for the answers.
I'm using Databricks SQL environment, not the Data Science & Engineering one. And, I scheduled the dashboard following this guideline: https://docs.databricks.com/sql/user/dashboards/index.html#automatically-refresh-a-dashboard
Also, the issue occurs on only one dashboard. The rest dashboards work fine.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-15-2022 01:56 AM
I created a new dashboard from scratch, and it's working properly now.
Anyway, the old one is still not working.
