Connecting Power BI & Tableau
Databricks · Databricks SQL & BI
Theory
BI tools connect to Databricks through a SQL warehouse using the Databricks connector, which needs the warehouse's Server hostname and HTTP path (from the warehouse's Connection details tab) and sign-in with OAuth (Microsoft Entra ID on Azure) or a personal access token. Partner Connect (Marketplace → Partner Connect integrations → View all) can set up the warehouse, service principal and connection for supported partner tools in a few clicks. For Power BI there is also Publish to Power BI: in Catalog Explorer select a schema or table, click Use with BI tools → Publish to Power BI workspace, sign in with Entra ID, choose the workspace and DirectQuery or Import mode, and Databricks creates the semantic model in the Power BI service for you.
Example: Ravi publishes main.sales to the Sales Analytics Power BI workspace in DirectQuery mode, then builds the report on the new semantic model.
Why we use it
Many companies already standardise on Power BI or Tableau. Connecting them to SQL warehouses keeps one governed copy of data in Unity Catalog and lets BI users reuse their tools while Databricks does the heavy compute.
When to use it
Use DirectQuery for large or frequently changing data that must stay in Databricks, and Import for smaller models needing the fastest visuals. Use Publish to Power BI to skip manual setup. Prefer AI/BI dashboards when no BI tool licence or semantic model is needed.
How it works
- Choose the BI tool
- Is it Power BI with a Premium/Fabric workspace? Yes: Catalog → Use with BI tools → Publish to Power BI workspace. No: Use the connector with hostname + HTTP path.
- Sign in with OAuth (Entra ID) or a token
- Large or fast-changing data? Yes: Pick DirectQuery. No: Pick Import.
- Build the report on the gold tables or views
Syntax
Connection details: SQL Warehouses → <warehouse> → Connection details (Server hostname, HTTP path, JDBC URL)
Power BI Desktop: Get data → Azure Databricks / Databricks → hostname + HTTP path → DirectQuery|Import
Publish to Power BI: Catalog → schema → Use with BI tools → Publish to Power BI workspace
Tableau: Connect → Databricks → Server hostname, HTTP path, OAuth/PATExample
Server hostname : adb-1234567890123456.7.azuredatabricks.net
HTTP path : /sql/1.0/warehouses/abc123def4567890
Catalog : main
Schema : sales
-- Gold view built for BI so the tool runs simple queries
CREATE OR REPLACE VIEW main.sales.v_city_sales AS
SELECT c.city, c.segment, o.order_date, SUM(o.amount) AS sales
FROM main.sales.orders o
JOIN main.sales.customers c ON o.customer_id = c.customer_id
GROUP BY c.city, c.segment, o.order_date;Key points
- Get Server hostname and HTTP path from the warehouse's Connection details tab
- Use OAuth/Entra ID sign-in over personal access tokens where possible
- Publish to Power BI needs Unity Catalog data and a Premium/Fabric capacity workspace
- DirectQuery sends every visual's query to the warehouse; size it for that load
- Build gold tables or views for BI instead of exposing raw tables
- Power BI users still need SELECT on the Unity Catalog objects