Clone a legacy dashboard to an AI/BI dashboard
Important
Databricks recommends using AI/BI dashboards (formerly Lakeview dashboards).
Original Databricks SQL dashboards are now called legacy dashboards. They will continue to receive critical bug fixes, but they won’t be updated with new features. Legacy dashboards will reach End of Life before the end of 2025. Databricks does not recommend creating new legacy dashboards.
Convert legacy dashboards using the migration tool or REST API. See Clone a legacy dashboard to an AI/BI dashboard for instructions on using the built-in migration tool. See Use Databricks APIs to manage dashboards for tutorials on creating and managing dashboards using the REST API.
This article describes how to create a new draft dashboard by cloning an existing legacy dashboard. Clone to AI/BI dashboard is a menu option in the UI that simplifies the conversion process. Clone to AI/BI dashboard is supported for legacy dashboards with a maximum of 100 widgets.
Using this button to create a new dashboard does not affect the original legacy dashboard or queries. Instead, this process uses the underlying queries and widget settings to create an equivalent dashboard.
Note
AI/BI dashboards (formerly Lakeview dashboards) do not support all legacy dashboard functionality. See Dashboards to learn about the available features.
Required permissions
You must have at least CAN VIEW permission on the legacy dashboard and all upstream queries, including those backing query-based drop-down list parameters. Legacy dashboards handle permissions for Databricks SQL queries and dashboards separately. Insufficient permissions on an upstream query causes the clone operation to fail.
Clone to AI/BI dashboard
The following animation shows a successful conversion.
Complete the following steps to clone a dashboard:
Click Clone to AI/BI dashboard.
You can access the Clone to AI/BI dashboard option from the following areas in the UI:
The Workspace file browser.
Right-click on the dashboard title, then click Clone to AI/BI dashboard. Alternatively, use the kebab menu to access the same option.
A legacy dashboard.
When viewing a saved dashboard: Click Clone to AI/BI dashboard from the kebab menu on an existing legacy dashboard.
When editing a saved dashboard: Click the kebab menu, then Clone to AI/BI.
(Optional) Specify a title and folder location for the new dashboard.
By default, you save the new dashboard in the same folder as the original legacy dashboard, with (AI/BI) appended to the original title. At this stage, you can retitle the new dashboard and choose a different destination folder.
Click Clone.
After the operation completes, look for a notification in the screen’s upper-right corner. Use the link to navigate to your new dashboard.
Review cloned dashboard results
A successful cloning operation creates a new draft dashboard. The existing legacy dashboard and related queries remain unchanged. The two dashboards are unrelated, and updates to one do not affect the other.
The new dashboard is created as a draft. It inherits any sharing permissions applied at the folder level. Permissions set on the source dashboard are not propagated.
All dashboard drafts are automatically granted Run as Viewer credentials, regardless of existing credential settings in the original legacy dashboard. When you publish a dashboard, you can choose to embed credentials or not. This affects how other users view and interact with your dashboard. See AI/BI dashboard ACLs to learn how to share and manage permissions for published dashboards.
Adjust legacy parameters
AI/BI dashboards offer limited support for parameters. The following parameter types are not supported:
Multi-value dropdown list
Date range
All supported parameter types persist in the new dashboard. Unsupported parameter types default to string
values. Previously set default values are retained.
Work with parameter widgets
During the clone operation, all legacy dashboard-level parameter widgets are converted to filters and appear at the top of the new dashboard Canvas. Date and time parameter widgets are added as Date picker filters, and all other types of parameter widgets are converted to Single value filters.
When you clone a dashboard that includes queries with parameters, the clone succeeds in recreating the target query, but the query needs to be adjusted to use named parameter syntax for it to succeed. You must update the syntax in the related dataset query to clear the error message shown in the parameter filter widget. Right-click on the widget to open and edit the connected dataset query. See Work with query parameters for syntax and examples.
Troubleshooting and manual adjustments
AI/BI dashboards do not support all features or chart types available in legacy dashboards. When you clone a legacy dashboard with unsupported elements, widgets on the new dashboard show an error message instead of a copy of the original widget. Commonly, errors occur from converting unsupported visualizations or filters. See Add or remove visualizations, text, and filter widgets on the canvas to learn which visualizations and filters are supported.
See Dashboard visualization types to learn how to use chart types supported in dashboards.