Power BI Architecture Choices for Azure Databricks (w/ Liping Huang) @HavensConsulting
Power BI Architecture Choices for Azure Databricks (w/ Liping Huang)  @HavensConsulting
Uploaded October 2026 | Updated November 2026, 3 days ago
Power BI gives you four main ways to report on data that lives in Azure Databricks: Direct Lake on OneLake, Direct Lake over mirrored Unity Catalog tables, DirectQuery against a Databricks SQL warehouse, and a composite model with import aggregations. Liping Huang wrote Microsoft's new white paper benchmarking all four side by side, and joins me to walk through the results.

The test runs the same TPC-DS data at roughly 26 million, 260 million and 2.6 billion rows, across cold, warm and hot cache, three filter scenarios and a 20-user load test. No pattern wins everywhere. Direct Lake holds up best for the warm and hot cache reports people open every day, queries that hit an aggregation table stay under 100ms at every volume, DirectQuery catches up (and sometimes wins) at 2.6 billion rows on an X-Large warehouse, and mirrored Unity Catalog tables slow down badly as the data grows.

We'll cover:
- How the benchmark was built, and why it measures what a report user waits for rather than raw engine speed
- Where each storage mode wins, and where it falls over
- Why distinct count was the hardest query in the set
- How to run the same kind of test on your own data before you pick an architecture

GUEST BIO (Liping Huang) πŸ‘€
Liping Huang is the CEO of Data Leaps and a Data & AI Architect, blogger, YouTuber, keynote speaker and user group organizer (ex-Microsoft, ex-Databricks). Liping works with Tabular Editor as Field CTO for APAC and is passionate about helping Power BI users build better semantic models faster, creating content about Tabular Editor, Power BI, Fabric and Databricks on the Data Leaps YouTube channel and at dataleaps.co.uk.

RELATED CONTENT πŸ”—
White Paper (PDF) -- raw.githubusercontent.com/microsoft/FabricCAT/main/Direct%20Lake_DirectQuery/Modern%20Power%20BI%20Architecture%20Choices.pdf
White Paper Announcement -- community.fabric.microsoft.com/blog/fbc_pbiupdatesblog/modern-power-bi-architecture-choices-for-reporting-on-azure-databricks-a-perform/5364286
Data Leaps -- dataleaps.co.uk
Data Leaps YouTube -- youtube.com/@dataleaps
Liping's LinkedIn -- linkedin.com/in/lipinght

BECOME A CHANNEL MEMBER πŸŽ‰
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join

CHECK OUT OUR MERCH STORE πŸ‘•
-- havens-consulting.creator-spring.com

LET'S CONNECT! πŸ§‘πŸ½β€πŸ€β€πŸ§‘πŸ½ 🌟
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting

TRAINING & DATA PLATFORM ARCHITECTURE βš™οΈ
Analytic Endeavors -- go-ae.org/hc-biz-training?v=-HEUbF7Jax4

BUSINESS PAGES πŸ“„
Home Page -- go-ae.org/hc-biz-home?v=-HEUbF7Jax4
Blog -- go-ae.org/hc-biz-blog?v=-HEUbF7Jax4
Blog Files -- go-ae.org/hc-biz-blog-files?v=-HEUbF7Jax4
Files & Templates -- go-ae.org/hc-biz-files?v=-HEUbF7Jax4
Consulting Services -- go-ae.org/hc-biz-consulting?v=-HEUbF7Jax4
Contact & Support -- go-ae.org/hc-biz-contact?v=-HEUbF7Jax4
Analytic Endeavors -- go-ae.org/hc-biz-enquiry?v=-HEUbF7Jax4

EMAIL US AT πŸ“§
info@havensconsulting.net

#PowerBI #Databricks #DirectLake #DirectQuery #MicrosoftFabric
Power BI Architecture Choices for Azure Databricks (w/ Liping Huang)Three Techniques for Curating the User Experience in Power BI!Creating a Measurement Framework (with Tommy Puglia)Speed Up Your Power BI Time Intelligence - with this Simple [DAX] ChangeIntroducing Fabric Workloads & PowerTable for Fabric Data Apps w/ Live Writeback (with Gopal)Power BI Report-Scoped Measures: 6 Patterns for Better ReportsIntroducing Inforiver Analytics+ (Charts+Cards+Tables) in Power BI (with Gopal Krishnamurthy)Power BI DataViz Championship: Watch the Winners & Finalists Present Their Reports!Creating Accessible Ops Data with Real-Time Intelligence in Fabric (with Will Thompson)Stop wasting compute! When to use Materialized Lake Views.Folder Organization for...Tables?!? Using Tabular Editor 3Creating a Calendar Slicer from a Matrix Table! (with Erik Svensen)
Havens Consulting |

Power BI Architecture Choices for Azure Databricks (w/ Liping Huang)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER