Concept
Schema drift occurs when the structure of source data changes, for example when columns are added, removed, reordered or change data type, which can break data pipelines and dataflows that are not designed to handle it.
| Type | Concept |
|---|
2025-11-03 · Video on YouTube
SharePoint Lists feel “free” and familiar, so teams prototype apps on them—and then accidentally build departments on sand. As lists multiply, you get broken lookups, 5k-item throttling, rogue permissions, attachment bloat, and schema drift. Governance…
2025-08-05 · Video on YouTube
Your phishing dashboard is lying to you. The “all good” charts hide near-miss clicks, silent investigations, and active campaigns threading your inboxes right now. We show how to tap Microsoft Defender’s buried signals and build living Power BI dashboards…
2025-08-05 · Video on YouTube
Your CRM insights are trapped behind Dataverse’s walls. In this guide, you’ll punch a clean hole straight into Microsoft Fabric—so sales, marketing, support, and product finally live on one dashboard. Learn the exact permissions to flip, the Dataverse tables…
2025-08-05 · Video on YouTube
If your Microsoft Fabric ingest “works” until a random Monday dashboard explodes, this episode is your wake-up call. We tear down the real difference between Dataflows Gen2 and direct Pipeline copy—and why picking wrong quietly injects duplicates…
2025-08-07 · Video on YouTube
This episode breaks down where Microsoft Copilot truly speeds up data work in Microsoft Fabric—and where you still need a human in the loop. You’ll see how Copilot catches schema issues at ingestion, suggests fixes (naming, types, dates, partitions) before…
Lists multiply and bring broken lookups, 5,000-item throttling, rogue permissions, attachment bloat and schema drift. Governance collapses quietly, and reporting turns into archaeology. · From the episode: Dataverse vs SharePoint for Power Apps…
CSVs and one-offs die on the next Defender update. Schema drift, mixed GUIDs and UPNs, API pagination gaps and fragile refresh schedules also hide spikes. · From the episode: Build Better Phishing Reports with Defender…
Ingesting only essential entities and needed columns, dropping legacy fields, speeds up results, then you shape relationships and lookups and handle schema drift. · From the episode: Connect Dataverse to Microsoft Fabric for CRM…
Use Dataflows Gen2 when data quality, schema drift or reusable business rules matter, and Pipelines for complex schedules, dependencies and alerts. Clean, stable sources may only need a Pipeline copy. · From the episode: Build Enterprise Ingest Pipelines in Microsoft…
It can work until gaps, duplicates and truncations surface weeks later. Pipeline copy does not cleanse data, so bad rows and schema drift land in the lakehouse. · From the episode: Build Enterprise Ingest Pipelines in Microsoft…
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Nobody has listed this topic yet. Add it to your profile.
Maintained by Mirko Peters (Microsoft MVP) · Last updated:
EN
Deutsch
Español
Français
Italiano
Português
Nederlands
Polski
Bahasa Indonesia
Русский
Українська
العربية
עברית
日本語
한국어