Arrow Database Connectivity (ADBC) driver for Power BI

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

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

Azure 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 = Databricks.Catalogs("adb-<workspace-id>.<random-number>.databricks.azure.cn", "/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