Skip to main content

Power BI with SAP 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 SAP 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.

This integration allows you to connect Power BI Desktop or the Power BI service to your Databricks SQL warehouses and configure secure authentication methods for enterprise deployments.

For guidance on how to best set up your dashboards and data, see Power BI cheat sheet.

Connect to Power BI

There are multiple ways to connect to SAP Databricks from Power BI.

Power BI platform

Description

Power BI Desktop

Connect Power BI Desktop to SAP Databricks clusters and SQL warehouses using Partner Connect or manual configuration.

Power BI service

Publish data from SAP Databricks to the Power BI service.

Additional connection setup options

There are additional setup options when connecting to SAP Databricks from Power BI.

Setup option

Description

Configure service principals on SAP Databricks for Power BI

Set up a service principal for machine-to-machine (M2M) OAuth before connecting to SAP Databricks from Power BI.

Arrow Database Connectivity (ADBC) driver for Power BI

Switch from the ODBC driver to the Arrow Database Connectivity (ADBC) driver when connecting to SAP Databricks from Power BI.