Episode Details
Back to Episodes
Fabric semantic model Copilot: fix the data model that makes your AI lie
Season 1
Published 5 months, 2 weeks ago
Description
Fabric semantic model Copilot: in this episode of M365.fm, Mirko Peters explains why your Fabric semantic model is quietly training Copilot to hallucinate—and how to rebuild your medallion layers so AI stops turning schema chaos into confident fiction. He shows how duplicate joins, missing semantics, and leaky Bronze‑to‑Gold pipelines feed Copilot ambiguous metadata, so the model rearranges half‑cleaned data into “insights” that sound brilliant and are mathematically wrong. You will learn why this is not an AI problem but an architecture problem: garbage in, confident out.
Mirko starts with the illusion of intelligence. Copilot does not “know” your business; it pattern‑matches from your column names, relationships, and lineage in Fabric. If your Gold layer mixes “Revenue” and “Total Sales” from different sources, joins on the wrong keys, or skips descriptions, Copilot treats them as one fuzzy concept. Ask “What was revenue last quarter?” and it happily merges incompatible measures, averages across mismatched grains, and hands you a beautiful, totally fabricated number—because your semantic model whispered inconsistency into its promptcontext.
He then dissects the Medallion myth—Bronze, Silver, Gold in theory versus what most tenants actually run. Bronze should quarantine raw chaos, Silver should enforce alignment, and Gold should contain certified logic, yet many pipelines let raw noise seep upward: direct queries to Bronze, half‑cleaned Silver, and Gold tables that still carry ID collisions and timestamp drift. Fabric then exposes this shaky lineage to Copilot data agents, so every shortcut in ETL becomes a semantic hallucination when AI tries to answer “why” instead of just “what.”
The episode highlights the missing semanticlayer as the real brain your data model forgot to build. Mirko explains how business definitions, measure logic, clear table roles, and rich descriptions turn raw tables into a vocabulary Copilot can actually trust. Without that, tables are memory with no comprehension, and Copilot behaves like a tourist reading signs phonetically—confident tone, zero context. You will hear how to use Fabric’s semantic model, lineage views, and data products to pin down “customer,” “revenue,” and “region” as precise concepts instead of suggestive labels.
You also get a practical governance and remediation playbook. Mirko walks through cleaning Bronze‑to‑Silver pipelines, enforcing keys and types, standardizing measures in Gold, and adding semantic annotations and descriptions before exposing anything to Copilot. He shares concrete checks—join audits, measure catalogs, lineage validation—and shows how to treat Copilot as a reflection engine: if you wouldn’t trust a KPI in a dashboard, you shouldn’t expose it as AI context. By the end, you will know how to turn Copilot from a storyteller on top of a shaky model into an accurate, explainable analyst grounded in disciplined Fabric architecture.
WHAT YOU WILL LEARN
Mirko starts with the illusion of intelligence. Copilot does not “know” your business; it pattern‑matches from your column names, relationships, and lineage in Fabric. If your Gold layer mixes “Revenue” and “Total Sales” from different sources, joins on the wrong keys, or skips descriptions, Copilot treats them as one fuzzy concept. Ask “What was revenue last quarter?” and it happily merges incompatible measures, averages across mismatched grains, and hands you a beautiful, totally fabricated number—because your semantic model whispered inconsistency into its promptcontext.
He then dissects the Medallion myth—Bronze, Silver, Gold in theory versus what most tenants actually run. Bronze should quarantine raw chaos, Silver should enforce alignment, and Gold should contain certified logic, yet many pipelines let raw noise seep upward: direct queries to Bronze, half‑cleaned Silver, and Gold tables that still carry ID collisions and timestamp drift. Fabric then exposes this shaky lineage to Copilot data agents, so every shortcut in ETL becomes a semantic hallucination when AI tries to answer “why” instead of just “what.”
The episode highlights the missing semanticlayer as the real brain your data model forgot to build. Mirko explains how business definitions, measure logic, clear table roles, and rich descriptions turn raw tables into a vocabulary Copilot can actually trust. Without that, tables are memory with no comprehension, and Copilot behaves like a tourist reading signs phonetically—confident tone, zero context. You will hear how to use Fabric’s semantic model, lineage views, and data products to pin down “customer,” “revenue,” and “region” as precise concepts instead of suggestive labels.
You also get a practical governance and remediation playbook. Mirko walks through cleaning Bronze‑to‑Silver pipelines, enforcing keys and types, standardizing measures in Gold, and adding semantic annotations and descriptions before exposing anything to Copilot. He shares concrete checks—join audits, measure catalogs, lineage validation—and shows how to treat Copilot as a reflection engine: if you wouldn’t trust a KPI in a dashboard, you shouldn’t expose it as AI context. By the end, you will know how to turn Copilot from a storyteller on top of a shaky model into an accurate, explainable analyst grounded in disciplined Fabric architecture.
WHAT YOU WILL LEARN
- Why bad Fabric schemas, joins, and medallion shortcuts make Copilot hallucinate with confidence.
- How Bronze, Silver, and Gold layers should really work to protect your semanticmodel from pollution.
- Why the semantic layer is the missing brain that tells Copilot what “revenue,” “customer,” and “region” truly mean.
- How to use lineage, tests, and measure catalogs to