Power BI Model Review

Paste in a semantic model (a TMDL export, a .bim/JSON model definition, or just a written-out list of tables, relationships, and measures) and get a structural review back: relationship design, calculated-column vs. measure choices, date-table setup, naming, star-schema shape, and common DAX mistakes. Corrected DAX is included wherever a fix applies.

What it’s for

Catching the modeling mistakes that don’t show up until a report is slow or a number is subtly wrong: bi-directional relationships between two dimension tables, calculated columns doing a measure’s job, time intelligence running against a column that isn’t really a date, CALCULATE filters that quietly override the wrong thing.

What it isn’t

It cannot connect to your workspace or a live model. Everything is inferred from the definition you provide. It doesn’t measure real query time, doesn’t know your row counts, and won’t tell you a report is slow, only what in the model is likely to make it slow. Treat the output as a structured second opinion, not a performance profile.

Getting a TMDL export

Power BI Desktop’s model view (or Tabular Editor) can serialize a model to TMDL folders, or use Get-BimFile/model.bim export from an existing workspace. A pasted list of tables/relationships/ measures works too if a full export isn’t handy. The review is only as thorough as what it’s given.

Reference

Star schema guidance · Bi-directional relationship guidance · Optimizing semantic models for Copilot

Skill by Tim Karlsson (╯°□°)╯︵ ┻━┻ Works 60% of the time, every time.