Hi @Thekenal ,
You can following link to first connect to Azure SQL server from databricks https://learn.microsoft.com/en-us/azure/databricks/connect/external-systems/sql-server.
Then follow dashboard creation within Databricks https://docs.databricks.com/en/dashboards/index.html.
Hope this helps.!
Regards,
Hari Prasad