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

(Livestream Replay) Making a Real Report Fully Bilingual: Harder Than you Thought! - with Bernat Agulló

DESCRIPTION 📄

Translating a model metadata does almost nothing in the direction of translating a real report. Translating the data is necessary, and you need to be able to translate titles and display names, even those coming from field parameters. Different strategies are needed to translate the different bits of the model and bring it back to the report so that with a single click everything changes the language. It's a lot of work.

GUEST BIO (Bernat Agulló)👤

Bernat is an enthusiast Power BI developer from Barcelona, part-owner of Esbrina and Data Platform MVP since 2022. He blogs mostly about calculation groups and Tabular Editor C# Scripting, but also about challenges he has found as a consultant. One of his latest challenges has been making a Japanese-only report turn into an English-Japanese report. Other recent highlights include modifying the report layer with a c# script or integrating Visual Studio and VS code with Tabular Editor to leverage GitHub Copilot to author C# Scripts.

RELATED CONTENT 🔗

Blog
LinkedIn
YouTube
GitHub
Bilingual Report Part 1
Bilingual Report Part 2

(Livestream Replay) Building Income Statements in Power BI - with Chris Barber

DESCRIPTION 📄

Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items.

Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas.

GUEST BIO 👤

Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI.

RELATED CONTENT 🔗

Website
Linkedin