How to connect to Azure Databricks from a DataFlow/Datamart(Preview) within the PBI Service

[iadalugama]

How to connect to Azure Databricks(SQL End Point) from a Dataflow/Datamart (Preview) within the PBI Service and create Reports. With this approach most of the customers can rely on WebUI for all the development (data transformation/ modeling / report and dashboarding)

 
First will create the PowerBI Datamart

(Announcing public preview of Datamart in Power BI https://powerbi.microsoft.com/en-us/blog/announcing-public-preview-of-datamart-in-power-bi/)

1. Go to Power BI premium workspace
   Click on the New, and from the list, select Datamart.

1. You can start by getting data from a dataflow, Excel or SQL Server or there are more than 150 sources. By selecting the Get data from another source. you will get the Spark Connector

1. Connect Azure Databricks SQL End point using PBI dataflow/Datamart

Use the 'Spark other' connector.

Set 'Server' as: https://SERVER_HOSTNAME:443/HTTP_PATH where SERVER_HOSTNAME and HTTP_PATH have been replaced appropriately.

Set 'Protocol' as: HTTP.

Set 'Username' as 'token'.

Set 'Password' as your token.

A guide to getting your server hostname and http path can be found here:

https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html

A guide to creating a token can be found here:

https://docs.databricks.com/dev-tools/api/latest/authentication.html

[Lukeh1]

Hi @iadalugama, just setting up a dataflow to Unity Catalog. There doesn't seem to be the option to add a native query as there is in Power BI Desktop. Is this by design or am I just missing this option there?

[v-zhangti]

Hi, @iadalugama 

Thank you for sharing. You can mark your post as the solution, so that your post will be searched more easily.

Best Regards

[iadalugama]

Hi ,

Please let me know how to do it. I'm new to  the forum.