Episode Details

Power BI measure cleanup, PBIP projects, TMDL, semantic model refactoring and bulk editing – this episode is for people searching “clean up Power BI measures”, “PBIP vs PBIX”, “rename measures in bulk”, “Power BI semantic model as code”, “TMDL Power BI” or “version control for Power BI models”. If your field list reads like goblin script and every dashboard change feels like tiptoeing around “TotalFinal_2”, this conversation shows how to turn your model into something you can actually refactor, diff and trust.

We start with the real pain: opening a model with 500+ measures named like “M1”, “Total1” and “NewCalc2”, where every choice requires drilling, cross‑checking and second‑guessing what the calculation does. That chaos doesn’t just annoy power users, it slows analysts, multiplies duplicate logic and quietly erodes trust in your numbers because no one is sure which “revenue” is the real source of truth. Manual cleanup by clicking through dialogs is the natural‑1 of model maintenance—slow, brittle and always falling behind incoming requests—so the question becomes: how do you treat this like code instead of a black box?

From there, we draw the line between PBIX as a sealed vault and PBIP as a project you can actually read. PBIX keeps everything in one binary container that’s fine for small, local work but terrible for diffing, versioning and bulk edits. PBIP flips that into a project‑ and text‑first layout where reports and models split into structured folders and files, so Git, VS Code and standard dev workflows finally have something meaningful to work with. You’ll hear why that shift—from “mystery file on the desktop” to “project in a repo”—unlocks visibility, revertability and automation, and sets the stage for real model refactoring instead of endless right‑click–rename loops.

Then we introduce TMDL (Tabular Model Definition Language) as the cheat code that lays your semantic model out in human‑readable text. Measures, columns and relationships become lines you can search, script and mass‑edit, turning color swaps, naming conventions and documentation passes from multi‑hour chores into a couple of global replaces and a safe commit. We walk through how to export and work with the tabular definition, why you always keep backups and follow Microsoft docs on supported workflows, and how treating your model as text lets you run true “model refactors” instead of spreadsheet‑style surgery.

WHAT YOU WILL LEARN

• Why messy measure naming quietly kills report usability, trust and team productivity.
• How PBIX locks your model in a binary box and where that hurts collaboration.
• How PBIP turns Power BI projects into readable, diff‑friendly folder structures.
• Why visibility, revertability and automation are the real win of project‑style formats.
• What TMDL is and how it exposes your semantic model as editable text.

  Listen Now