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.
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.
In PowerBI Desktop, go to Get Data > Azure and select the Azure Databricks connector.
Although the label says Azure Databricks, the connector works with Databricks on AWS.
Paste the Server Hostname and HTTP Path you retrieved in Step 1.
Select your Data Connectivity mode. For information about the difference between Import and DirectQuery, see Use DirectQuery in Power BI Desktop.
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.
Select the Databricks data to query from the Power BI Navigator.
The Databricks connector does not support web proxy.