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 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


![Speed Up Your Power BI Time Intelligence - with this Simple [DAX] Change
Microsofts new calendar-based time intelligence isnt magic, but its a necessary optimization for every new model (and existing ones with performance issues).
The Results:
β
Simplified query plans
β
Fewer rows scanned by Storage Engine (SE)
β
Same DAX, better syntax
The performance gains come from smarter query optimization. If youre working with large fact tables and time-based calculations, this is how the engine should be working.
What I cover:
- How calendar-based functions optimize the storage engine
- DAX Studio query plan comparison (side-by-side)
- Setting up calendar categories in Power BI
- Migrating from classic DATEADD to calendar-based syntax
- FREE Power BI Calendar Template (PBIX)
RELATED CONTENT π
Calendar Template: https://go.analyticendeavors.com/e2606e69a5
Calendar-based time intelligence https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-time-intelligence#calendar-based-time-intelligence-preview
Blog Announcement https://powerbi.microsoft.com/blog/calendar-based-time-intelligence-time-intelligence-tailored-preview/
Introducing calendar-based time intelligence in DAX https://www.sqlbi.com/articles/introducing-calendar-based-time-intelligence-in-dax/
BECOME A CHANNEL MEMBER π
https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
https://havens-consulting.creator-spring.com/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
https://www.facebook.com/havensconsulting
HAVENS CONSULTING PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=0JphIBU-jDs
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=0JphIBU-jDs
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=0JphIBU-jDs
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=0JphIBU-jDs
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=0JphIBU-jDs
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=0JphIBU-jDs
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=0JphIBU-jDs
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel Speed Up Your Power BI Time Intelligence - with this Simple [DAX] Change](https://i.ytimg.com/vi/0JphIBU-jDs/mqdefault.jpg)







