Fabric semantic-model architecture options

F64-first design | Public documentation checked 12 November 2026 | Read-only architecture study; no customer environment inspected.
Counts, complete 15-year coverage and memory targets remain assumptions or proposed criteria, not measured outcomes.

Editable Excalidraw board | One-page comparison | Comparison PDF | Evidence and one-week test plan (Markdown)

Colour identifies semantic access mode. On narrow screens, scroll each diagram horizontally or open its full-size SVG.

Option 1a - Lead: F64 summary model; detail stays in Snowflake

Editable Excalidraw | Full-size SVG

Option 1b - F64 summary model; copied detail in OneLake

Editable Excalidraw | Full-size SVG

Option 0 - Current state: reported issues and Direct Lake guardrails

Editable Excalidraw | Full-size SVG

Option 2 - F64 alternative: Import aggregates + automatic detail routing

Editable Excalidraw | Full-size SVG

Option 3 - LAST RESORT: scale only after F64 model-change tests fail

Editable Excalidraw | Full-size SVG

Decision path - change the model first; scale is a gated fallback

Editable Excalidraw | Full-size SVG