Power Query DELETING Your Relationships? Here's How to Restore Them Using TMDL!

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

RELATED CONTENT 🔗

Lineage Tags for Power BI Semantic Models
TMDL View

Dynamic Column Headers (with Field Parameters) in Power BI!

Video by: Reid Havens

Learn how to combine Field Parameters, relationships, and DAX to create dynamic "column" headers in Power BI. Tune in to learn more!

RELATED CONTENT 🔗

Field Parameters

Simplifying [DAX] with Staging Tables & Relationships in Power BI

Video by: Reid Havens

Learn how to leverage model tables/columns, and relationships to simplify your DAX code for your Power BI datasets (models), leading to simpler measures, and potentially more efficient (faster) calculations and visual queries. Tune in to learn more!

New Relationship Pane Walkthrough for Power BI Desktop

Video by: Reid Havens

Let's review the NEW relationship Pane (in preview as of February 2023) that can be found in the Model View for Power BI Desktop! We'll compare it to the traditional relationship pop up window as well! Tune in to learn more.