Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Microsoft Power BI is a business analytics service that provides interactive visualizations with self-service business intelligence capabilities. When you integrate Power BI with Azure 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 Azure Databricks, connect Power BI Desktop to your Azure 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 Azure Databricks from Power BI.
| Power BI platform | Description |
|---|---|
| Power BI Desktop | Connect Power BI Desktop to Azure Databricks clusters and SQL warehouses using manual configuration. |
| Power BI service | Publish data from Azure 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 Azure Databricks from Power BI.
| Setup option | Description |
|---|---|
| Configure service principals on Azure Databricks for Power BI | Set up a service principal for machine-to-machine (M2M) OAuth before connecting to Azure Databricks from Power BI Desktop or the Power BI service. |
| Arrow Database Connectivity (ADBC) driver for Power BI | Switch from the ODBC driver to the Arrow Database Connectivity (ADBC) driver when connecting to Azure Databricks from Power BI. |