Power BI

Microsoft Power BI is a business analytics service that provides interactive visualizations with self-service business intelligence capabilities, enabling end users to create reports and dashboards by themselves without having to depend on information technology staff or database administrators.

When you use Databricks as a data source with Power BI, you can bring the advantages of Databricks performance and technology beyond data scientists and data engineers to all business users.

You can connect Power BI Desktop to your Databricks clusters using the built-in Databricks connector.

Requirements

  • Power BI Desktop 2.85.681.0 or above. Download the latest version.

  • Decide how you are going to authenticate from Power BI to Databricks.

    You can authenticate using a personal access token (recommended) or a username and password.

Connect to Databricks from Power BI

Step 1: Get Databricks connection information

  1. Get the server hostname, port, and HTTP path.
  2. If you authenticate using a personal access token, get a token.

Step 2: Configure Databricks connection in Power BI

  1. In PowerBI Desktop, go to Get Data > Azure and select the Azure Databricks connector.

    Databricks connector in Get Data list

    Note

    Although the label says Azure Databricks, the connector works with Databricks on AWS.

  2. Click Connect.

  3. Paste the Server Hostname and HTTP Path you retrieved in Step 1.

    Databricks JDBC/ODBC configuration
  4. Select your Data Connectivity mode. For information about the difference between Import and DirectQuery, see Use DirectQuery in Power BI Desktop.

  5. Click OK.

  6. At the authentication prompt, select the way to authenticate to Databricks:

    • Username and password: Use your Databricks username (usually your email address) and password. Username and password authentication may be disabled if your Databricks workspace is enabled for single sign-on. If you cannot log in using your Databricks username and password, use a personal access token.
    • Personal access token: Use the personal access token you retrieved in Step 1.
  7. Click Connect.

  8. Select the Databricks data to query from the Power BI Navigator.

    Power BI Navigator

Limitations

The Databricks connector does not support web proxy.