Back to the work
BIIn use

Report documentation and review tool

Reads a full Power BI model, writes its documentation and checks it against 17 review rules.

The problem

A Power BI model needs clear documentation and a review before release.

Faults should be caught before a report goes out, not after.

What I did

Built an internal tool that reads a full Power BI model.

It writes the documentation: measures, data lineage (where each number comes from), table relationships, data preparation steps and a column dictionary.

Wrote the 17 review rules behind it, each graded by severity.

The result

Issues from weak table relationships to passwords left in data connections are caught before release.

Tools

  • Power BI