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

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