Power BI

Important

The Azure Databricks connector that is 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 Azure Databricks as a data source with Power BI, you can bring the advantages of Azure Databricks performance and technology beyond data scientists and data engineers to all business users.

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

Requirements

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

Step 1: Get Azure Databricks connection information

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

Step 2: Configure Azure 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

  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 you want to log in to Azure Databricks:

    Azure Active Directory: Use your Azure account credentials. Click the Sign in button. In the sign-in dialog, enter your Azure account username (email, phone, or Skype).

    Personal Access Token: Use your Azure Databricks-generated personal access token you retrieved in Step 1.

    Note

    Username / Password authentication is not enabled for access to Azure Databricks. It is recommended that you use Azure Active Directory authentication.

  7. Click Connect.

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

    Power BI Navigator