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.
- 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.
In PowerBI Desktop, go to Get Data > Azure and select the Azure Databricks connector.
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:
Select the Databricks data to query from the Power BI Navigator.
The Databricks connector does not support web proxy.