Read-only audit

Northwind Retail · Retail · sample

AI

This is a finished audit of a synthetic model.

Run the same static audit on your own PBIP in seconds, without an account.

Audit your model
68/ 100

Not ready for production

507085

The model has critical issues that lead to incorrect financial reporting. The 'Budget vs Actual' calculation is fundamentally wrong due to a missing model relationship, and time intelligence measures are inconsistent and based on the wrong date columns. Furthermore, the model relies on local Excel files, making it unrefreshable and unmanageable in the Power BI Service. These foundational modeling and data source issues must be addressed before the model can be considered reliable for business decisions.

45 findings · 7 critical · 6 verified fixes · 5 hygiene notes, not counted in the score

Tables

7

Measures

14

Relationships

6

Pages

–

no report layer

Critical

7

AI findings

12

6 fixes

Fix these first

Ordered by severity, confidence and how many visuals depend on the object.

By area

Sub-scores out of 100; click to filter.

Verified fixes

Rewrites checked against your model and reviewed for semantic equivalence.

The model

Shape, sources and the report layer.

Shape

Fact tables1
Dimensions4
Helper / parameter2
Relationships1 critical6
Bidirectional1
Date table markedyes

Data sources

SQL Server3
Excel workbook1 local2
Power Query2

Report layer

Upload the PBIP with its .Report folder to get lineage, unused measures and page findings.

363 static checks · 38 firedAI review: 12 findings, 6 rewrites verified · $0.61Engine semantic-pargemini-2.5-pro+gemini-2.5-pro9/22/2026, 1:54:41 PM

Nothing from this audit is stored. How your data is handled