Power BI

Preview

The Databricks connector integrated in Power BI Desktop version 2.85.681.0 and above is in Public Preview.

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.

Step 1: Get Databricks connection information

  1. Get a personal access token.
  2. Get the server hostname, port, and HTTP path.

Step 2: Configure Databricks cluster 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,” this 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.

    Note

    Authentication using Azure Active Directory is not available for Databricks workspaces on AWS.

  7. Click Connect.

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

    Power BI Navigator