Forum Discussion

mohsarif's avatar
mohsarif
New Member
7 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...
Tips and Tricks
  • rohit1991's avatar
    rohit1991
    7 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.

Natarajan_M's avatar
Natarajan_M
Icon for Super User rankSuper User
7 months ago

Hi mohsarif  , I'm using the below approach to load the data .You can get the custom query into the dataset :

Get data -> Azure databricks -> Fill in the credentials -> next -> Select a table-> Transform data 



 


Advanced query 



Add the below query:

let
Source = Value.NativeQuery(Databricks.Catalogs(@Hostname_value, @HTTPPath_value, [Catalog=null, Database=null, EnableAutomaticProxyDiscovery="enabled"])
{[Name=@Database_value,Kind="Database"]}[Data],
"
Select * from the sampletable " ,
null,
[EnableFolding=true])
in
Source

@Hostname_value Host name

@HTTPPath_value Http path

@Database_value Database

 

Thanks 


If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster