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 and Databricks SQL endpoints by using the built-in Azure Databricks connector. (Although the connector is labelled as Azure Databricks, it works with Databricks on AWS as well.)

Requirements

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

    Note

    Power BI Desktop requires Windows. An alternative for other operating systems is to run Power BI Desktop on a physical host or a Windows-based virtual machine and then connect to it from your operating system.

    If you use a version of Power BI Desktop below 2.85.681.0, you also need to install the Databricks ODBC driver in the same environment as Power BI Desktop.

Connect with Power BI Desktop by using Partner Connect

You can use Databricks Partner Connect to connect a cluster or SQL endpoint with Power BI Desktop in just a few clicks.

  1. Make sure your Databricks account, workspace, and the signed-in user meet the requirements for Partner Connect.

  2. In the sidebar, click Partner Connect button Partner Connect.

  3. Click the Power BI tile.

  4. In the Connect to partner dialog, for Compute, choose the name of the Databricks compute resource that you want to connect. If your selected persona is Data Science & Engineering or Databricks Machine Learning, choose a cluster or SQL endpoint. If your selected persona is Databricks SQL, choose a SQL endpoint.

  5. Choose Download connection file.

  6. Open the downloaded connection file, which starts Power BI Desktop.

  7. In Power BI Desktop, enter your authentication credentials:

    • Personal Access Token: Enter your Databricks personal access token from the Requirements.
    • Username / Password: Enter your Databricks username (typically your email address) and password from the Requirements. Username and password authentication may be disabled if your Databricks workspace is enabled for single sign-on (SSO). If you cannot log in by using your Databricks username and password, try using the Personal Access Token option instead.
    • Azure Active Directory: Not applicable.
  8. Click Connect.

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

    Power BI Navigator

Connect with Power BI Desktop

Follow these instructions to connect to a cluster or SQL endpoint with Power BI Desktop.

Note

To connect faster with Power BI Desktop, use Partner Connect.

  1. Get the Server Hostname and HTTP Path.

  2. Start Power BI Desktop.

  3. Click Get data or File > Get data.

  4. Click Get data to get started.

  5. Search for Databricks, choose the Azure Databricks connector, and click Connect.

    Note

    Although the connector is named Azure Databricks, it works with Databricks on AWS.

  6. Enter the Server Hostname and HTTP Path.

  7. Select your Data Connectivity mode. For information about the difference between Import and DirectQuery, see Use DirectQuery in Power BI Desktop.

  8. Click OK.

  9. Enter your authentication credentials:

    • Personal Access Token: Enter your Databricks personal access token from the Requirements.
    • Username / Password: Enter your Databricks username (typically your email address) and password from the Requirements. Username and password authentication may be disabled if your Databricks workspace is enabled for single sign-on (SSO). If you cannot log in by using your Databricks username and password, try using the Personal Access Token option instead.
    • Azure Active Directory: Not applicable.
  10. Click Connect.

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

    Power BI Navigator

Power BI Delta Sharing Connector

The Power BI Delta Sharing Connector allows users to discover, analyze and visualize datasets shared with them through the Delta Sharing open protocol. The protocol enables secure exchange of datasets across products and platforms by leveraging REST and cloud storage.

Requirements

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

After you download the credentials file, open it with a text editor to retrieve the endpoint URL and the token.

Connect to Databricks

To connect to Databricks by using the Delta Sharing Connector, complete the following steps:

  1. Open Power BI Desktop.
  2. On the Get Data menu, search for Delta Sharing.
  3. Select the connector and click Connect.
  4. Enter the endpoint URL that you copied from the credentials file into the Delta Sharing Server URL field.
  5. Optionally, in the Advanced Options tab, set a Row Limit for the maximum number of rows that you can download. This is set to 1 million rows by default.
  6. Click OK.
  7. For Authentication, copy the token that you retrieved from the credentials file into Bearer Token.
  8. Click Connect.

Limitations

The Databricks connector does not support web proxy.

The Delta Sharing Connector is not yet available in the Power BI service.

The data that the Delta Sharing Connector loads must fit into the memory of your machine. To ensure this, the connector limits the number of imported rows to the Row Limit that was set earlier.