Databricks SQL dashboard refresh

[noimeta]

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?

[Vivian_Wilfred]

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.

[noimeta]

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.

[noimeta · Accepted solution]

I created a new dashboard from scratch, and it's working properly now.

Anyway, the old one is still not working.