Skip to main content

Arrow Database Connectivity (ADBC) driver for Power BI

Preview

This feature is in Public Preview.

This page describes how to switch to the Arrow Database Connectivity (ADBC) driver for Power BI dashboards that connect to Databricks data sources.

You can use the ADBC driver instead of the ODBC driver for the Databricks connector in Power BI. To use the ADBC driver, use Power BI Desktop 2.145.1105.0 (July 2025 release) or above.

Databricks continues to enhance this connector and add new capabilities. Upgrade to the latest version, try it out, and Submit product feedback.

Switch to the ADBC driver

To switch to the ADBC driver, do the following:

  1. Open the desired dashboard in Power BI.
  2. Click Transform Data.
  3. Click Advanced Editor in the Query option section.
  4. Specify Implementation="2.0" to switch to the ADBC driver.
    let
    Source = DatabricksMultiCloud.Catalogs("<instance-name>.gcp.databricks.net", "/sql/1.0/warehouses/<sql-warehouse-id>",
    [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null, Implementation="2.0"]),
    powerbi_Database = Source{[Name="powerbi",Kind="Database"]}[Data],
    default_Schema = powerbi_Database{[Name="default",Kind="Schema"]}[Data],
    dashboard_data_Table = default_Schema{[Name="dashboard_data",Kind="Table"]}[Data]
    in
    dashboard_data_Table