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.

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.

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
  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:

  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.