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

  1. Choose the BI tool
  2. 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.
  3. Sign in with OAuth (Entra ID) or a token
  4. Large or fast-changing data? Yes: Pick DirectQuery. No: Pick Import.
  5. 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/PAT

Example

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

Databricks topics

Databricks Fundamentals

Compute

Notebooks & Development

Apache Spark on Databricks

Delta Lake

Unity Catalog & Governance

Data Ingestion

Declarative Pipelines (Lakeflow)

Lakeflow Jobs

Databricks SQL & BI

Architecture, Performance & Cost

Machine Learning & AI

Certification & Interview

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Master Databricks

The lakehouse platform from the ground up: Apache Spark, Delta Lake, Unity Catalog, Lakeflow pipelines and jobs, Databricks SQL and MLflow. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice SQL / Spark SQL Sharpen the SQL you use in Databricks SQL and Spark SQL: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Databricks  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Databricks needs a real workspace — there's no in-browser engine for it. Click Copy above, then paste it into a notebook or the SQL editor in Databricks Free Edition (free, no credit card) and run it on serverless compute.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic