fabric-semantic-model-auditlisted

Audit an existing Power BI or Fabric semantic model and report on its shape, relationship health, memory cost and downstream readiness — a review of a finished model, not authoring guidance. Use when asked to audit, review, assess or health-check a semantic model, to judge whether one is a real star schema, to explain why a model is slow or bloated, or to investigate inactive relationships, snowflake chains, role-playing dimensions, bidirectional filters, ambiguous filter paths, limited vs. regular relationships, or high-cardinality columns. Covers the three evidence tiers — TMDL on disk with no capacity, `INFO.VIEW.*` over executeQueries, and Best Practice Analyzer / Model Memory Analyzer via `sempy.fabric` in a Fabric notebook — and the storage-mode split that makes import-mode relationship guidance wrong for Direct Lake. For authoring TMDL use fabric-tmdl; for reviewing a diff use code-review; for scripting an open Desktop model use pbid-tom-live.
wardawgmalvicious/agent-config · ★ 0 · AI & Automation · score 75

Install: claude install-skill wardawgmalvicious/agent-config

# Auditing a semantic model A **review procedure over a finished model** — stand back from it and report on what it is, not on the line you are typing. Everything else in the payload that touches a semantic model is authoring guidance: `fabric-tmdl` and `coding-tmdl.md` own conventions, `fabric-tmdl-api` owns deployment, `code-review` reviews a diff. This owns the corpus. The output is a set of **findings**, not a rewrite. Do not edit the model unless asked separately. ## 1. Establish storage mode before anything else This gates every memory claim you are about to make, and getting it wrong is this skill's main way of producing a confidently wrong answer. Read `mode:` on each table's partition in `definition/tables/*.tmdl`: ``` grep -rh "mode:" definition/tables/*.tmdl | sort | uniq -c ``` `import`, `directLake`, `directQuery` or `dual`. Mixed modes mean a **composite model**, which in turn means source groups — and cross source group relationships are *limited* (§5). Direct Lake has two forms, **on OneLake** and **on SQL analytics endpoint**, and they differ on nearly every limitation that matters to remediation; the connection expression in `expressions.tmdl` tells you which. State the storage mode in the finding report header. An audit that prescribes an import-mode fix to a Direct Lake model is wrong even when every individual sentence in it is true. ## 2. Three tiers of evidence **Not a fallback chain.** Each tier answers questions the others cannot, and you sho