An inherited Power BI model is easier to assess when you first decide whether it needs no change, a small tweak, a refactor or a rebuild. This process is useful for Power BI developers and analysts who have to understand an unfamiliar model before changing its logic or relationships. Pragmatic Works demonstrates a practical review of a deliberately messy model, including how to identify likely facts, dimensions and relationships that need investigation.
This is a review method for an existing model, not a new Power BI feature. Its central idea is to avoid treating every unfamiliar model as a rebuild project. First check whether the model answers the questions the business asks, whether it refreshes reliably and whether its structure is still recognizable.
The decision flow separates four possible responses: leave the model alone, tweak it, refactor it or rebuild it. In the example flow, a model that answers business questions and refreshes reliably can be left alone. If the structure is difficult to understand, consider whether you can still identify facts, dimensions and grain before deciding how much change is needed.
The demonstration gives rough effort and risk levels for the choices: a tweak is measured in hours with low risk, a refactor in days with medium risk, and a rebuild in weeks with high risk. It also recommends shipping a refactor in increments and getting sign-off before a rebuild.
This approach is aimed at people taking responsibility for a model built by someone else, whether that person left the organization or ownership simply changed. It can help an analyst or developer get oriented before attempting repairs. You need access to the model and enough familiarity with the business questions it is expected to answer to evaluate whether it is doing its job.
Start in the model view and inspect the tables and their relationships. The method does not depend on assuming that table names are accurate: the example includes vague names such as “SKU-ish” and “Who_Bought_This.” Columns and relationships can help reveal what those tables represent. When names are unclear, the demonstration switches to table view to inspect the data.
This sequence helps build an inventory of what appears to work and what needs more attention. It does not require changing every relationship during the first pass. The demonstration’s emphasis is on understanding the model and identifying a sensible starting point before moving on to changes.
A model view can suggest a table’s role, but names and relationships alone may not settle the question. The example checks table contents and key columns when the first interpretation is uncertain. It also shows that a table described as a dimension may need further work in Power Query to become a suitable dimension.
Many-to-many relationships and bidirectional filters are warning signs to examine, not proof that every affected table should be replaced. A model may contain useful parts alongside broken links: the shared date table in the demonstration still supports both purchase and return facts. Preserve and understand those working pieces as you choose between a small tweak, incremental refactoring and a higher-risk rebuild.
Use the Power BI topic page for related coverage. The key decision is whether the model remains understandable and dependable for its users, not whether every table can be made to look tidy immediately.
Check whether it answers the business’s questions and refreshes reliably. Then identify likely fact and dimension tables and inspect their relationships.
Use the model’s business fit, refresh reliability and recognizable structure to guide the decision. The demonstrated flow treats rebuilding as a higher-effort, higher-risk option than tweaking or refactoring.
Look for events, measures and identifiers to find likely facts, then inspect connected tables and their columns to identify dimensions. Table view can help when names are unclear.
Review many-to-many relationships, bidirectional filters, broken links and potential fact tables disguised by unclear names. Also look for working relationships, such as a shared date table.