Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

kayu1
‎02-26-2021 08:58 AM

Announcing General Availability (GA) of the Power BI connector for Databricks

We are excited to announce General Availability (GA) of the Power BI connector for Databricks, including the ability to connect to Databricks without an on-premises data gateway as well as support for Azure Active Directory (AAD) authentication and SSO in DirectQuery mode in the Power BI service.

Now you can efficiently, in more secure manner, consume data directly from Databricks via Power BI. With this native integration of Power BI with Azure Databricks, end users can create reports and dashboards by themselves without having to depend upon IT staff or database administrators. Business Analysts can create the report in Power BI Desktop with Databricks as the data source and publish to Power BI service for end users such as business executives to consume the report, all in a secure and seamless manner, via Azure AD authentication.

The Databricks connector enables seamless Power BI connectivity through the following key capabilities:

  • Support for Import and DirectQuery mode. Import is fast and rich, but not always suitable, as Databricks deals with data at cloud scale.
  • No need for an on-premises gateway. Thus eliminating the friction associated with deploying and managing gateways.
  • Authentication through AAD. User identities are the same between Power BI and Azure Databricks.
  • SSO-based on AAD authentication. With SSO enabled in the data source definition, users opening or refreshing a report in DirectQuery mode are authenticated and authorized seamlessly with their Power BI (AAD) identities to access Databricks.
  • Secure Access to Azure Data Lake Storage scenario with Power BI - With Azure AD authentication and identity passthrough, users can see only data in Power BI that they have been granted permissions to.
The following screenshot shows a Call Detail Record (CDR) Power BI report that works with over 1 billion rows of data in a Databricks data source configured for SSO.

Announcing_General_Availability_GA_of_the_Power_BI_connector_for_DatabricksAnnouncing_General_Availability_GA_of_the_Power_BI_connector_for_Databricks

The Power BI connector for Databricks is the result of an on-going collaboration between the Power BI and Azure Databricks product teams and Databricks Inc. For further details, see the Databricks connector documentation for Power BI Desktop, for Power BI Service, and related articles on the Databricks website.

0