Power BI with Databricks
Microsoft Power BI is a business analytics service that provides interactive visualizations with self-service business intelligence capabilities. When you integrate Power BI with Databricks, you bring scalable data processing and high-performance analytics to all business users, enabling them to create rich reports and dashboards without depending on IT staff or database administrators.
The integration allows you to publish data sets directly from Databricks, connect Power BI Desktop to your Databricks clusters and Databricks SQL warehouses, and configure secure authentication methods for enterprise deployments.
Connect to Power BI
There are multiple ways to connect to Databricks from Power BI.
Power BI platform | Description |
|---|---|
Connect Power BI Desktop to Databricks clusters and SQL warehouses using Partner Connect or manual configuration. | |
Publish data from Databricks to the Power BI service. |
If you want to use a Power BI task to orchestrate your Power BI semantic models automatically, you must create a Power BI connection in Unity Catalog first.
Additional connection setup options
There are additional setup options when connecting to Databricks from Power BI.
Setup option | Description |
|---|---|
Set up a service principal for machine-to-machine (M2M) OAuth before connecting to Databricks from Power BI Desktop or the Power BI service. | |
Switch from the ODBC driver to the Arrow Database Connectivity (ADBC) driver when connecting to Databricks from Power BI. |