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

Mastering Roster & Timesheet Reporting: From Minutes to Millions - with Kane Snyder

DATE/TIME 📅

September 5th at 1:30 PM (Pacific Time)

DESCRIPTION 📄

Ready to transform your workforce data from basic hour tracking into strategic business intelligence? This deep dive takes you through real-world techniques for handling complex timesheet analytics with minute-level precision. We'll tackle the challenging DAX calculations, data modeling considerations, and performance optimizations that make the difference between simple reports and enterprise-grade workforce insights that actually drive decisions.

What You'll Learn:

• Advanced time intelligence DAX for overlapping shifts and complex scenarios

• Data modeling strategies and optimization for granular timesheet data

• Roster vs. actual comparison techniques

• Real-world implementation patterns from enterprise solutions

Perfect for:

Power BI developers, business analysts, and anyone dealing with complex workforce reporting requirements who wants to move beyond basic time summaries to actionable workforce intelligence.

GUEST BIO 👤

I’m Kane Snyder, a Head of Analytics, Principal Fabric Architect and Analytics Practice Lead with deep expertise in Power BI, DAX and Microsoft Fabric. I’ve guided multiple organisations—across banking and finance, tourism, risk management, environmental emissions, HR, IT governance, law, freight, transport and sales—to build end-to-end analytics solutions that balance cost efficiency with business value. I have a background in business management and have held numerous leadership roles both in business and the analytics space.

I live on the Sunshine Coast in Queensland Australia where I spend my time surfing, camping, 4 wheel driving and playing music.

RELATED CONTENT 🔗

SQLBI Events in Progress DAX Pattern
Kanes Blog
Kanes LinkedIn

Sneak Peek: New PBI Multi-Tool Cleanup Features! Themes, Visuals & Bookmark Removal

Video by: Reid Havens

Get an exclusive first look at the upcoming Power BI Multi-Tool cleanup features!

🧹 This update makes report maintenance easier than ever by automatically removing unused:

• Themes

• Visuals

• Bookmarks

Streamline your PBIP files, reduce clutter, and keep your Power BI projects running smoothly. Perfect for anyone looking to optimize and organize their reports with just a few clicks.

RELATED CONTENT 🔗

Analytic Endeavors Power BI Multi-Tool

Dynamic Matrix Columns in Power BI: Show/Hide Based on Row Hierarchy

Video by: Reid Havens

Ever wish your Power BI matrix could respond intelligently to what’s visible in the row hierarchy? In this video, I’ll show you how to create a dynamic matrix where column values, like department, title, or other employee attributes appear or disappear based on what’s selected in your row-level hierarchy.

We’ll combine a few clever modeling tricks to keep your matrix clean, relevant, and user-driven. Tune in to learn more!

RELATED CONTENT 🔗

Field Parameters in Power BI