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
