Uploaded June 2026 | Updated November 2026, 2 days ago
Every report hitting your raw tables runs the same expensive joins and aggregations over and over, even when the underlying data hasn't moved. Materialized Lake Views in Microsoft Fabric pre-compute those results once and store them as Delta tables in OneLake, so consumers read finished numbers instead of recalculating from scratch.
In this video I cover what MLVs actually are, how the automatic refresh logic decides between skip, incremental, and full rebuild, the Spark SQL syntax to create and manage them, and where they sit in a medallion architecture (think of them as a "Gold+" layer).
The part worth sticking around for: point Direct Lake at an MLV instead of your raw tables and you get pre-aggregated data at import speed. In the example here, a 50 million row fact table collapses to around 500K. Fewer rows means faster transcoding into VertiPaq and a lot less DirectQuery fallback risk. That's the single best reason to pair the two.
I also get into when NOT to use them, because they're not free. Sub-minute volatile data, tiny tables, and row-level security needs are all cases where an MLV is the wrong tool.
RELATED CONTENT π
Materialized Lake Views Guide -- go-ae.org/0aba06d045
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
BUSINESS PAGES π
Home Page - havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Analytic Endeavors-- go.analyticendeavors.com/2baab4564a
EMAIL US AT π§
info@havensconsulting.net
#MicrosoftFabric #PowerBI #DirectLake #DataEngineering #OneLake
Every report hitting your raw tables runs the same expensive joins and aggregations over and over, even when the underlying data hasn't moved. Materialized Lake Views in Microsoft Fabric pre-compute those results once and store them as Delta tables in OneLake, so consumers read finished numbers instead of recalculating from scratch.
In this video I cover what MLVs actually are, how the automatic refresh logic decides between skip, incremental, and full rebuild, the Spark SQL syntax to create and manage them, and where they sit in a medallion architecture (think of them as a "Gold+" layer).
The part worth sticking around for: point Direct Lake at an MLV instead of your raw tables and you get pre-aggregated data at import speed. In the example here, a 50 million row fact table collapses to around 500K. Fewer rows means faster transcoding into VertiPaq and a lot less DirectQuery fallback risk. That's the single best reason to pair the two.
I also get into when NOT to use them, because they're not free. Sub-minute volatile data, tiny tables, and row-level security needs are all cases where an MLV is the wrong tool.
RELATED CONTENT π
Materialized Lake Views Guide -- go-ae.org/0aba06d045
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
BUSINESS PAGES π
Home Page - havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=pAxKtzuP9cQ
Analytic Endeavors-- go.analyticendeavors.com/2baab4564a
EMAIL US AT π§
info@havensconsulting.net
#MicrosoftFabric #PowerBI #DirectLake #DataEngineering #OneLake
![Visual Calculations β Making [DAX] Easier (with Jeroen ter Heerdt)
This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you donβt even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature!
Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.
GUEST BIO (Jeroen ter Heerdt) π€
Jeroen ter Heerdt is a Product Manager with Microsoft. He works on Power BI and is passionate about all things data; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, advanced analytics, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision, and hands-on experience into his talks.
RELATED CONTENT π
Blog http://www.dutchdatadude.com
LinkedIn https://www.linkedin.com/in/jeroenterheerdt
Understanding Visual Calculations https://learn.microsoft.com/en-us/power-platform/release-plan/2023wave2/power-bi/visual-calculations
VIDEO CHAPTERS πΊ
0:00 - Video Start
5:00 - Start of Live stream
LETS CONNECT! π§π½βπ€βπ§π½π
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE π
https://havens-consulting.creator-spring.com/
HAVENS CONSULTING PAGES π
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=pV_OgvL4XqY
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #visualcalcs #visualcalculations #reporting Visual Calculations β Making [DAX] Easier (with Jeroen ter Heerdt)](https://i.ytimg.com/vi/pV_OgvL4XqY/mqdefault.jpg)


![Revisiting Common Calculation Group Patterns in Power BI!
Because of the recent release of adding calculation groups directly from Power BI Desktop. Well explore three common calculation group patterns and use-cases. Tune in to learn more!
RELATED CONTENT π
Semantic Model View & Calculation Groups https://youtu.be/OEuctMIbN9Y
Auto-Scaling for [DAX] KPI Cards? https://youtu.be/T6svewf3YGc
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
VIDEO CHAPTERS π₯
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=q5Ri_8BjCl4
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=q5Ri_8BjCl4
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=q5Ri_8BjCl4
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=q5Ri_8BjCl4
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=q5Ri_8BjCl4
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=q5Ri_8BjCl4
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=q5Ri_8BjCl4
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #calculationgroups Revisiting Common Calculation Group Patterns in Power BI!](https://i.ytimg.com/vi/q5Ri_8BjCl4/mqdefault.jpg)





![Custom Data Labels, Curved Lines, and Leader Line Labels (OH MY!)
Learn how to enhance your visualizations with custom DAX data labels plus leader lines. Additionally, learn how to upgrade your native line chart visuals using the smooth line option. Tune in to see them in action!
RELATED CONTENT π
Stylized & Informative Visual Header Tooltips https://youtu.be/GyBcpQZ1azE
[DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!? https://youtu.be/EtrI-q0-ewE
Improved Analytics Line https://youtu.be/v9iG869BUbM
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
VIDEO CHAPTERS π₯
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=soyp7Vd1vhc
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=soyp7Vd1vhc
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=soyp7Vd1vhc
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=soyp7Vd1vhc
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=soyp7Vd1vhc
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=soyp7Vd1vhc
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=soyp7Vd1vhc
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #visuals #visualizations Custom Data Labels, Curved Lines, and Leader Line Labels (OH MY!)](https://i.ytimg.com/vi/soyp7Vd1vhc/mqdefault.jpg)
