Forum Discussion
Databricks is not available as source in Report Builder
- 6 months ago
Hii mohsarif
To connect Azure Databricks, use one of these supported methods:
Option 1 (Recommended): Use ODBC
-
Install the Databricks ODBC driver.
-
Create a DSN using your Databricks Server Hostname, HTTP Path, and Personal Access Token.
-
In Report Builder >> Data Source >> ODBC >> select the DSN.
-
Now you can write custom SQL queries in the Dataset query designer.
Option 2: Use Azure Synapse / SQL Endpoint
If using Databricks SQL Warehouse, connect via Microsoft SQL Server connection type using:-
Server = Databricks SQL endpoint
-
Authentication = Token (or Azure AD)
The reason you don’t see Databricks directly is because Report Builder only supports standard providers (SQL, ODBC, OLE DB, etc.), so Databricks must be accessed through one of those drivers.
-
Hi mohsarif
Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to rohit1991 , anilelmastasi , cengizhanarslan and Natarajan_M for offering helpful suggestions.
Could you let us know if the suggested solution resolved your issue? If it's still pending, please let us know any further details so we can help.
Best regards,
Community Support Team.