Azure Databricks

Note

This connector is owned and provided by Databricks.

Summary

Property	Value
Connector	Azure Databricks
Products	Power BI (semantic models) Power Query Online
Release state	General availability
Category	Database
Authentication kinds	Azure Active Directory Databricks Client Credentials Personal Access Token
Product-specific authentication	Service Principal (Power BI / Fabric) Workspace Identity (Power BI / Fabric)
Data source kind	Databricks
Function Reference Documentation	Databricks.Catalogs Databricks.Contents Databricks.Query

Important

The Azure Databricks connector for Power BI now supports the Arrow Database Connectivity (ADBC) driver. This connector is transitioning from the embedded Simba Spark ODBC driver to the Databricks ADBC driver. For migration guidance, key dates, and admin controls, see Transition from ODBC to ADBC drivers in Power BI and Fabric.

Prerequisites

For private networks, you'll need to implement the following network settings:

• *.blob.core.windows.net* and *.store.core.windows.net need to be open in your network environment.
• This list of certificate downloads and revocations also need to be added to your allow list.
• If firewall support is enabled on your Databricks workspace storage account, you must configure either a virtual network data gateway or an on-premises data gateway to allow private access to the storage account. This ensures that the Fabric Power BI service can continue to access the workspace storage account and that CloudFetch continues to function correctly. Alternatively, you can disable CloudFetch with the configuration EnableQueryResultDownload=0.

Supported capabilities

• Import
• DirectQuery (Power BI semantic models)

Parameters

Entry point: Databricks.Catalogs

Required parameter count: 2

Parameter	Display name	Required	Type	Group	Description	Sample values	Nullable
host	Server Hostname	Yes	text		The hostname of the Databricks server.	"example.azuredatabricks.net"	false
httpPath	HTTP Path	Yes	text		The HTTP path of the cluster.	"/sql/1.0/warehouses/abcdef1234567890"	false
options	Advanced Options	No	nullable record	Advanced Options			true

Fields in options

Field	Display name	Required	Type	Group	Description	Declared default	Allowed values	Sample values	Nullable	Optional	Allowed value metadata	Declared allowed values
options.Catalog	Default catalog	No	text	Advanced Options	Select a default catalog for the connection.				false	true
options.Database	Database	No	text	Advanced Options	Limit the connection to the selected database. This might make listing tables faster, however it will prevent query folding for queries that hit multiple different databases.				false	true
options.QueryTags	Query tags	No	text	Advanced Options	Key-value tags for tracking queries in system.query.history table.			"tag1:value1,tag2:value2"	false	true
options.EnableAutomaticProxyDiscovery	Automatic Proxy Discovery	No	text	Advanced Options	This enables automatic Windows System wide automatic Proxy Discovery.		"enabled" (Enabled); "disabled" (Disabled (default))		false	true	[{"Metadata": {"Documentation.Caption": "Enabled", "Documentation.Name": "AutomaticProxyDiscoveryFlag.Enabled"}, "Value": "enabled"}, {"Metadata": {"Documentation.Caption": "Disabled (default)", "Documentation.Name": "AutomaticProxyDiscoveryFlag.Disabled"}, "Value": "disabled"}]	["enabled", "disabled"]
options.Implementation	Implementation	No	text	Advanced Options	Use '2.0 (beta)' to specify ADBC. The 'default' value will use the environment configuration to determine which driver to use.	"2.0"	"2.0" (2.0 - ADBC); null (System Default)		false	true		["2.0", null]
options.Protocol	Protocol	No	text	Advanced Options	Specifies the protocol used by the ADBC driver. Select 'REST (SEA)' to use the Statement Execution API. When not set, the driver default (Thrift) is used.	null	null (Default); "rest" (REST (SEA))		false	true		[null, "rest"]

Connect from Power Query Desktop

AWS, Azure or GCP

To connect to Databricks from Power Query Desktop, take the following steps:

1. In the Get Data experience, search for Databricks to shortlist the Databricks connector, Azure Databricks. Use the Azure Databricks connector for all Databricks SQL Warehouse data unless you've been instructed otherwise by your Databricks rep.

   

2. Provide the Server hostname and HTTP Path for your Databricks SQL Warehouse. Refer to Configure the Databricks ODBC and JDBC drivers for instructions to look up your "Server hostname" and "HTTP Path". Enter this information accordingly. You can optionally supply a default catalog and/or database under Advanced options. Select OK to continue.

   

3. Provide your credentials to authenticate with your Databricks SQL Warehouse. There are three options for credentials:

   • Databricks Client Credentials. Refer to Databricks OAuth M2M for instructions on generating Databricks OAuth M2M Client Credentials.

   • Personal Access Token (usable for AWS, Azure, or GCP). For instructions on generating a Personal Access Token (PAT), see Personal access tokens.

   • Azure Active Directory (usable only for Azure). Sign in to your organizational account using the browser popup.

     

   Note

   Once you enter your credentials for a particular Databricks SQL Warehouse, Power BI Desktop caches and reuses those same credentials in subsequent connection attempts. You can modify those credentials by going to File > Options and settings > Data source settings. More information: Change the authentication method

4. Once you successfully connect, the Navigator shows the data available to you on the cluster. You can choose either Transform Data to transform the data using Power Query or Load to load the data in Power Query Desktop.

   

Connect from Power Query Online

To connect to Databricks from Power Query Online, take the following steps:

1. Select the Azure Databricks option in the get data experience. Different apps have different ways of getting to the Power Query Online get data experience. For more information about how to get to the Power Query Online get data experience from your app, go to Where to get data.

   Shortlist the available Databricks connectors with the search box. Use the Azure Databricks connector for all Databricks SQL Warehouse data unless you've been instructed otherwise by your Databricks rep.

   

2. Enter the Server hostname and HTTP Path for your Databricks SQL Warehouse. Refer to Configure the Databricks ODBC and JDBC drivers for instructions to look up your "Server hostname" and "HTTP Path". You can optionally supply a default catalog and/or database under Advanced options.

   

3. Provide your credentials to authenticate with your Databricks SQL Warehouse. There are four options for credentials:

   • Databricks Client Credentials. For instructions on generating Databricks OAuth M2M Client Credentials, see Databricks OAuth M2M.
   • Personal Access Token (usable for AWS, Azure, or GCP). Refer to Personal access tokens for instructions on generating a Personal Access Token (PAT).
   • Azure Active Directory (usable only for Azure). Sign in to your organizational account using the browser popup.
   • Service principal (usable only for Azure). Authenticate with a Microsoft Entra ID service principal. This option is available when configuring a cloud or gateway connection.

4. Once you successfully connect, the Navigator appears and displays the data available on the server. Select your data in the navigator. Then select Next to transform the data in Power Query.

   

Additional information

Arrow Database Connectivity driver connector implementation

You can use the Arrow Database Connectivity (ADBC) driver for the Azure Databricks connector in Power BI. As we continue to enhance and add new capabilities to this connector, we recommend that you to upgrade to the latest version to try it out and submit product feedback.

Note

Since February 2026, new connections created in Power BI Desktop or Power BI Service will automatically use the Arrow Database Connectivity (ADBC) driver by default. Existing connections will continue to use ODBC unless you manually update them to ADBC.

To switch to the ADBC driver:

1. Open your desired dashboard in Power BI.
2. Select Transform Data.
3. Select Advanced Editor in the Query option section.
4. Specify Implementation="2.0" for ADBC.

   let
       Source = Databricks.Catalogs("adb-<workspace-id>.<random-number>.azuredatabricks.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
   

Limitations and considerations

• The Azure Databricks connector supports web proxy. However, automatic proxy settings defined in .pac files aren't supported.
• In the Azure Databricks connector, the Databricks.Query data source isn't supported in combination with Power BI semantic model's DirectQuery mode.