Connect to Azure Databricks with Tabular Editor using Power Query (not ODBC)

[smoortema]

I am trying to create a Data Source in Tabular Editor representing the connection to Azure Databricks SQL Warehouse. This way, I can use the data source in the tables' M code. I would like to use the Power Query connection and not ODBC, because Power Query connection supports Direct Query.

How to set up the connection? Which configuration parameters and values should be used when setting up the data source?

I have already managed to create a connection by reverse engineering it, loading a table in Power BI Desktop using Power Query, then connecting to the pbix file with Tabular Editor. Here, the connection is written in the M script of the table, instead of the Data Source. I could repeat the same code for connection for each table, but it would be better to store it only once, and not once per table.

In the Tabular Editor documentation, it recommends to import the tables in SSDT and figure out how the data source is configured there, but in SSDT, Azure Databricks connection is not listed as an option.

Importing Tables | Tabular Editor Documentation

[lbendlin]

Looks like "Azure Databricks"  leads straight back to the "SQL Server"  connector

[smoortema]

Where is this screenshot from? Power BI Desktop gives a different interface for me. It asks for Server Hostname and HTTP Path.

[lbendlin]

Power BI Desktop Version: 2.139.2054.0 64-bit (January 2025)