Document the AdventureWorks Model in 60 Seconds
Everyone in the Power BI world has met AdventureWorks, which makes it the perfect model to judge a documentation tool on: you already know what the output should say. Below is the complete data dictionary the Model Documenter generates from an AdventureWorksDW2022 semantic model, free to download and reuse.
Download the Sample
- .docx AdventureWorksDW data dictionary (Word) The audit-ready deliverable 13 KB
- .xlsx AdventureWorksDW data dictionary (Excel) The filterable working copy, one sheet per object type 16 KB
What the Dictionary Covers
- Every table and column: types, formats, keys, hidden flags
- All 11 measures with their full DAX, display folders, and format strings
- All 8 relationships, including the two inactive date relationships (DueDate, ShipDate) that role-playing dimensions require
- The row-level security role and its table filter DAX, the part auditors ask for first and most documentation skips
- For each measure, the measures it uses and the measures that use it
- A Model Checks section: the DAX Lint rules run on every measure, plus model rules such as two-way filters, month columns with no sort order and data sources typed into every table. This sample gets two notes: a month name column with no sort column, and the same
localhostserver in all of its tables - Storage mode for each table (every table in this sample is Import). The dictionary does not include the SQL or M source behind each partition
Why This Matters Beyond AdventureWorks
Model documentation is the deliverable everyone agrees should exist and nobody wants to hand-write, so it is perpetually stale. Generating it from the model definition means it is correct by construction: rerun it after every change and the handoff document, the audit binder, and the new-hire orientation doc are always the current model, not the model as of last quarter.