Forum Discussion

mohsarif's avatar
mohsarif
New Member
6 months ago
Solved

Databricks is not available as source in Report Builder

Hi Community,   Hope you are doing well. I am trying to build Paginated Report in Power BI Report Builder on top of Azure Data bricks. I got 2 issues:   1. There is no Connection Type available...
  • rohit1991's avatar
    6 months ago

    Hii mohsarif 

     

    To connect Azure Databricks, use one of these supported methods:

    Option 1 (Recommended): Use ODBC

    1. Install the Databricks ODBC driver.

    2. Create a DSN using your Databricks Server Hostname, HTTP Path, and Personal Access Token.

    3. In Report Builder >> Data Source >> ODBC >> select the DSN.

    4. 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.