Uploaded September 2025 | Updated November 2026, 3 days ago
Have your Power BI relationships mysteriously disappeared after changing a Power Query? You're not alone! When you modify Power Query transformations - even seemingly harmless changes - Power BI's data lineage breaks and deletes your relationships. But there's a solution!
In this video, I'll show you how to use TMDL (Tabular Model Definition Language) view to backup your relationships BEFORE making Power Query changes, so you can easily restore them when lineage breaks.
๐ฏ What You'll Learn:
- How data lineage can break your relationships
- How to save your relationships using TMDL view before making changes
- How to restore relationships after Power Query modifications delete them
- Real-world scenarios where this problem happens (Excel โ Database migrations, adding transformations, etc.)
RELATED CONTENT ๐
Lineage Tags for Power BI Semantic Models -- learn.microsoft.com/en-us/analysis-services/tom/lineage-tags-for-power-bi-semantic-models
TMDL View -- learn.microsoft.com/en-us/power-bi/transform-model/desktop-tmdl-view
BECOME A CHANNEL MEMBER ๐
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
-- facebook.com/havensconsulting
VIDEO CHAPTERS ๐ฅ
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES ๐
Home Page - havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel
Have your Power BI relationships mysteriously disappeared after changing a Power Query? You're not alone! When you modify Power Query transformations - even seemingly harmless changes - Power BI's data lineage breaks and deletes your relationships. But there's a solution!
In this video, I'll show you how to use TMDL (Tabular Model Definition Language) view to backup your relationships BEFORE making Power Query changes, so you can easily restore them when lineage breaks.
๐ฏ What You'll Learn:
- How data lineage can break your relationships
- How to save your relationships using TMDL view before making changes
- How to restore relationships after Power Query modifications delete them
- Real-world scenarios where this problem happens (Excel โ Database migrations, adding transformations, etc.)
RELATED CONTENT ๐
Lineage Tags for Power BI Semantic Models -- learn.microsoft.com/en-us/analysis-services/tom/lineage-tags-for-power-bi-semantic-models
TMDL View -- learn.microsoft.com/en-us/power-bi/transform-model/desktop-tmdl-view
BECOME A CHANNEL MEMBER ๐
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
-- facebook.com/havensconsulting
VIDEO CHAPTERS ๐ฅ
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES ๐
Home Page - havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
Contact & Support - havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=S_ZD_ld6IkY
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel










![Simplify Power BI DAX with Visual Calculations
If youve ever written a running total in DAX, you know its more work than it has any right to be. CALCULATE, FILTER, a column reference you have to get exactly right, and a quiet prayer that it behaves at the subtotal level. Visual calculations let you write RUNNINGSUM([Sales]) and get on with your day.
Theyre a calculation layer that lives inside the visual itself, working on the data thats already been aggregated rather than querying the whole model. Thats also why theyre often faster, sometimes dramatically so on DirectQuery.
I walk through the core functions (running totals, moving averages, PREVIOUS and NEXT for period comparisons, FIRST, LAST, INDEX, and RANK), then the hierarchy functions like COLLAPSE and EXPAND that make % of parent and % of grand total almost trivial. We also get into AXIS and RESET, which control the direction a calculation runs and where it restarts, because thats the part that quietly breaks peoples running totals across years.
One honest caveat. Yes, theyre easier and faster. But because each one only lives in a single visual, they can fragment your business logic across reports if youre not careful, so I cover when a visual calc is the right call and when it really should be a centralized measure.
RELATED CONTENT ๐
Visual Calculations Guide https://go-ae.org/hc-yt-visual-calc-guide
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://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
BUSINESS PAGES ๐
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=VEwGH6i2aeE
Analytic Endeavors https://go.analyticendeavors.com/86d335734f
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #DAX #DataVisualization #MicrosoftFabric #BusinessIntelligence Simplify Power BI DAX with Visual Calculations](https://i.ytimg.com/vi/VEwGH6i2aeE/mqdefault.jpg)