Connect Power BI with Azure Databricks (Spark)

This post will show how to connect Power BI Desktop with Azure Databricks (Spark).

1. Launch Power BI Desktop, click Get Data in the toolbar, and click More….

2. Search for Spark and select the “Spark” option.

3. Add the URL inside Server and select HTTP as the protocol

Example of Original Databricks URL:

jdbc:spark://ukwest.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/5119652226182151/0118–080121-tones701;AuthMech=3;UID=token;PWD=dapi5cfbb3df11a8edee4ce02e113e11670e

Create your URL, use the example below to help you understand the pattern.

https://ukwest.azuredatabricks.net:443/sql/protocolv1/o/o/5119652226182151/0118–080121-tones701

4. Inside user name add “token” and inside password use the string after PWD

In the URL search for UID and PWD.

UID = user
PWD = password

UID=token;PWD=dapi5cfbb3df11a8edee4ce02e113e11670e

user: token
password: dapi5cfbb3df11a8edee4ce02e113e11670e
(The password will be in the URL, the PWD string)

After you click connect you will see the Spark Tables as the example below:

Microsoft documentation:
https://docs.microsoft.com/en-us/azure/databricks/bi/power-bi#connect-power-bi-desktop-to-a-databricks-cluster