PlantOps BI

Model Compare

Load two versions of a semantic model and see which tables, columns, measures, partitions, parameters, calculation items, relationships and security roles were added, removed, renamed or changed, with a line diff of the DAX and M. Use it before a release, or to review a pull request. Nothing is uploaded; the page cannot make network requests.

Before

The version in production, or the last release.

Nothing loaded yet.

After

The version you are about to publish.

Nothing loaded yet.

Load both versions to compare them. The TMDL project format is needed (File > Save as > Power BI Project).

    What It Compares

    Names match without regard to case, as they do in Power BI, and a change of case alone shows as renamed. Any other rename shows as one removed and one added, since nothing in the files links the old name to the new. Measures are matched across the whole model, so one moved to another table shows as moved. Relationships are matched by the two columns they join, since their names are usually generated ids. A measure renamed to a different name shows as one removed and one added. DAX and M are compared after trimming trailing spaces. Not compared: hierarchies, perspectives, translations, annotations and report pages. For a full dictionary of either version, use the Model Documenter.