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.
This article provides information about connecting business intelligence (BI) tools to Unity Catalog. It lists typical integrations, followed by a table that compares BI tool support for Unity Catalog and other Azure Databricks features.
JDBC
To access data registered in Unity Catalog over JDBC, use Simba JDBC driver version 2.6.21 or above.
ODBC
To access data registered in Unity Catalog over ODBC, use Simba ODBC driver version 2.6.19 or above.
Looker
To use data managed by Unity Catalog in Looker, use the Simba JDBC driver version 2.6.21 or above. See Connect to Looker.
Power BI
To access data registered in Unity Catalog using Microsoft Power BI, use Power BI Desktop version 2.98.683.0 or above (October 2021 release).
See Connect Power BI to Azure Databricks.
Tableau
To access data registered in Unity Catalog using Tableau, use Tableau Desktop version 2021.4 with Simba ODBC driver version 2.6.19 or above.
See Connect Tableau and Azure Databricks.
Supported features by BI tool
| Feature | Power BI* | Tableau* | Looker | JDBC/ODBC |
|---|---|---|---|---|
| End-user authorization | ✓ | ✓ | ✓ | ✓ |
| Audits | ✓ | ✓ | ✓ | ✓ |
| Lineage | ✓ | ✓ | ✓ | ✓ |
| Row- and column- level security | ✓ | ✓ | ✓ | ✓ |
| Lakehouse federated data | ✓ | ✓ | ✓ | ✓ |
| Delta Sharing data | ✓ | ✓ | ✓ | ✓ |
| Query objects secured with grants | ✓ | ✓ | ✓ | ✓ |
| Dynamic views | ✓ | ✓ | ✓ | ✓ |
| Materialized views | ✓ | ✓ | ✓ | ✓ |
| Streaming tables | ✓ | ✓ | ✓ | ✓ |
| Python functions & AI models via SQL | ✓ | ✓ | ✓ | ✓ |
*Configured using live query mode.