Video by: Reid Havens
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:
Why relationships disappear even when column names and data types stay the same
What "breaking data lineage" actually means
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.)
