The Power BI connector for Azure Databricks enables seamless connectivity through the following key capabilities:
- Support for Azure Active Directory (Azure AD): Users can use their Azure AD credentials to connect to Azure Databricks. Administrators no longer need to generate Personal Access Tokens (PAT) tokens for authentication.
- Simple connection configuration: The Azure Databricks connector is natively integrated into Power BI. Connections to Azure Databricks are configured with a couple of clicks, where users select Databricks as a data source, enter the Databricks-specific connection details and authenticate.
- Secure and direct access to Azure Data Lake Storage via DirectQuery: When using Power BI DirectQuery, data is directly accessed in Databricks, and enabling users to query and visualize large datasets. Power query results are always fresh and Delta Lake data security controls are enforced.
- Faster results via Databricks ODBC: The Databricks ODBC driver has been optimized with reduced query latency, increased result transfer speed and improved metadata retrieval performance.
Learn more.