Data Governance Episodes

Here’s the thing nobody admits about modern governance: it isn’t designed to finish—it’s designed to continue. This episode follows a sleepless journey through Microsoft 365 governance, where dashboards glow amber, scores hover just shy of “good,” and every review promises progress without resolution. What looks like control is really choreography: CSV exports, compliance scores, audit logs, and Power BI heatmaps that signal motion while preserving stasis. Readiness reviews don’t uncover surprises—they normalize them. Unmanaged Teams linger, access reviews expire untouched, and policies stay in “audit mode” forever, not because they failed, but because enforcing them would force a decision. Across budget renewals, workshops, and license true-ups, the same pattern repeats. Amber becomes the safest color. It justifies more tooling, more time, and more funding—without ever reaching green, where the work would have to stop. Governance turns into a ritual: evidence is produced, risks…

Everything was green, nothing failed, and that was the problem. In this episode, we follow a meticulous, almost obsessive investigation into a Microsoft 365 tenant where compliance, retention, versioning, and discovery all appeared perfectly healthy. Policies were applied, dashboards were stable, audit logs reconciled, and every control reported success. So the team ran it again, and again, each time widening the lens. What emerged wasn’t a broken system, but a subtle shift in behavior hiding behind correct outcomes. Through repeated loops, the podcast reveals how autosave, co-authoring, and intelligent versioning quietly compress history at the moment of creation, long before retention or discovery can act. Activity did not equal preserved versions, and survival often happened before governance could even see the data. The core insight is unsettling: compliance tools retain what exists, not what you assume should exist. If your governance model depends on granular history under moder…

In this episode, we walk through how platform systems fail quietly long before they fail loudly, and how to stop that drift with discipline instead of heroics. The discussion starts with early warning signals: inconsistent SharePoint design, fragile Power Apps, and Power Automate flows that succeed until a small change pushes them over the edge. None of these are outages by themselves, but together they create instability that compounds over time. The episode breaks the problem down layer by layer. SharePoint is treated as a collaboration substrate that requires clear schemas, indexed columns, restrained relationships, and clean permission models. Power Apps are framed as deterministic systems, not improvisational interfaces, with strict control over state, delegation, and data writes. Power Automate flows are examined as operational systems that need scoped triggers, concurrency limits, checkpoints, and explicit failure handling to remain reliable. AI and copilots are positione…

You think Power BI performance problems are a dashboard issue? Think again — the real problem is hiding upstream. In this episode, we break down Microsoft Fabric as a living data ecosystem and explain why Power BI only thrives when the entire architecture beneath it is healthy. Using a clear, story-driven analogy, we explore how OneLake acts as the unified data foundation, why domains and workspaces define responsibility and governance, and how the bronze–silver–gold data layering model keeps analytics trustworthy and scalable. You’ll learn the real difference between Lakehouse and Warehouse, when to use each, and how shortcuts, mirroring, and Dataflows Gen2 move data without duplication or chaos. We dive deep into semantic models as the shared language of analytics, showing how clean star schemas, Direct Lake, and certified models eliminate refresh pain and metric confusion. The episode also covers governance that actually works: capacity management, lineage, sensitivity lab…

In this episode, we dive deep into how organizations can stop drowning in documents and start building a true AI-powered knowledge engine with SharePoint Premium and Copilot readiness. You’ll learn how data naturally drifts into entropy—and how the right structure, governance, and AI models give it orbit and purpose. We break down practical, real-world steps to deploy AI for content extraction, classification, and tagging, while keeping humans firmly in the loop. From finance invoice automation to legal contract intelligence and image tagging at scale, this episode shows how to turn noise into signal with measurable ROI—this quarter, not someday. We also uncover the guardrails most teams miss: oversharing risks, semantic search exposure, sensitivity labels, and restricted access controls that keep AI powerful but safe. If you want faster decisions, cleaner data, and Copilot answers grounded in truth—not guesswork—this episode is your blueprint for governed, scalable AI in Microsoft…

Your AI isn’t broken, it’s telling the truth about your mess. In this episode, we expose why Copilot, search, and AI agents give confident but wrong answers inside Microsoft 365 and how the real problem isn’t prompts, models, or tools, it’s governance. You’ll hear how permission drift, orphaned Teams, ROT data, shadow sites, and overzealous restrictions quietly poison AI grounding, causing hallucinations that sound just like you. Through real admin stories and before and after examples, this episode explains why AI reads structure, permissions, labels, and residue, not intent, and why cleaning the house changes everything. We break down the five governance binds that actually fix AI accuracy: lean information architecture, lifecycle management, sensitivity labels, DLP, and retention, all working together as a repeatable ritual. If you want Copilot answers that are current, precise, and trustworthy, this episode shows why governance is the foundation of AI truth and how to start fixing…

Your Power BI theme might be the reason your dashboard is silently lying to you. In this breakdown, you’ll learn why a Power BI theme isn’t “just branding” — it’s a containment field that keeps critical signals visible. The video exposes five hidden failures that make alerts fade, subtotals vanish inside matrices, tooltips turn unreadable on hover, card visuals lose hierarchy, and slicers disguise selected vs. unselected states. The fix is ruthless and repeatable: enforce WCAG-style contrast rules (4.5:1 for text, 3:1 for charts, 7:1 for high-risk KPIs), add redundancy (icons + labels, not color-only), and lock everything in a governed theme JSON. You’ll also get a pass/fail validation protocol, pixel-tested contrast checks, and a workflow for versioned organizational themes, pull-request gates, and CI-ready reporting so “pretty” never outranks data truth.

Most data leaks do not start with hackers. They start with kindness, convenience, and one small decision to “just share it.” In Part 2 of The Knot in the Cloud, we move to the edge of the system, where documents leave their birthplace and chaos either multiplies or stops cold. This episode explains how auto-labeling in Microsoft Purview acts as a silent sense, recognizing contracts, evidence, and sensitive data before humans forget to care. You’ll see how labels, content types, DLP, retention, and Copilot work together to prevent forks, stop oversharing, and preserve a single version of truth across Dynamics and Microsoft 365. Instead of slowing work down, classification removes guessing, replaces memory with law, and turns audits into dashboards instead of interrogations. This is not about catching mistakes. It is about lifting the floor so mistakes rarely happen at all.

Every organization has lost a document it desperately needed. A contract, a decision, a version marked “final” that was never truly final. This episode exposes why that chaos is not accidental, but structural. In Part 1, we explore how document sprawl silently fractures sales, projects, and compliance when SharePoint is treated like a file dump instead of an evidence system. Dynamics records events with precision, but without documents bound to those events, timelines collapse under scrutiny. Email attachments, private Teams channels, personal OneDrives, and endless folder hierarchies create parallel realities where proof cannot be summoned on demand. Audits fail quietly. Deals slow down. Trust erodes. This episode introduces the core problem: unstructured time. Without identity, metadata, retention, and enforced linkage between Dynamics, SharePoint, Purview, and Copilot, organizations repeat the same mistakes quarter after quarter. The documents are not lost. They are displaced in ti…

In a recent podcast, Mirko Peters discussed the critical importance of effective document management and compliance in organizations, emphasizing that lost documents can lead to organizational failure. He presented strategies for building an audit-ready Enterprise Content Management (ECM) system in the cloud, using tools like SharePoint and Purview to create a robust defense against regulatory scrutiny. The conversation highlighted the alignment with standards such as ISO 27001, GDPR, and SOC 2, which are essential for surviving inspections. Peters outlined a structured approach to document management, including defining ownership, lifecycle management, and implementing data loss prevention (DLP) measures. He stressed the need for clear policies, sensitivity labels, and regular audits to ensure compliance and mitigate insider risks. The discussion also covered the importance of collaboration between HR, legal, and security teams to maintain a culture of compliance. This podcast …

What if Dynamics 365 Sales was your membership engine, not just a sales CRM? In this episode, we show how to repurpose Dynamics 365 Sales and Dataverse to run memberships, committees, and partner programs without custom software. Instead of leads and pipeline, you model organizations, members, committees, positions, assignments, and partner programs using standard tables, relationships, and business process flows. We walk through a practical membership data model, where memberships bridge contacts and organizations, roles stay flexible, and lifecycle stages replace sales drama with clear registration, validation, active, renewal, and archive steps. You’ll learn how Outlook, Teams, SharePoint, Power Automate, and Power BI plug in automatically when you stay inside the Microsoft Power Platform guardrails. We also unpack common failure patterns like duplicate member tables, overusing JavaScript and plugins, and mixing sales and non-sales lifecycles. The result is a secure, scalable, audi…

Your data platform isn’t a platform – it’s a staged illusion. In this episode, I break down why your “modern stack” of Power BI, ad hoc pipelines, shadow CSVs and seven conflicting dashboards is really entropy in disguise. We dissect the real reason Microsoft Fabric exists: not as another feature bundle, but as an attack on fragmentation with one identity via Entra, one storage plane with OneLake over Delta, one governance story with Purview and one monitoring surface you can actually explain to an exec. I walk through the medallion architecture as a hard contract, not a vibe: bronze as immutable evidence, silver as validated truth, gold as curated meaning delivered through Direct Lake semantic models. You’ll also get a concrete seven day path to a minimum viable Fabric platform with clear access paths, shortcuts instead of copies, enforced lineage and governance that finally survives the “where did this number come from?” question.

Are your dashboards secretly preaching lies? In this episode, we turn data governance into a full-on revival meeting. We name the heresy of ad-hoc share links, stale workspaces and broken RLS that quietly corrupt your “single source of truth”. Then we reveal the doctrine of distribution: org apps as the one canonical doorway, certified datasets as scripture, and deployment pipelines as your release liturgy. You’ll hear a concrete 30-day rite for dragging your analytics from chaos to canon, with clear roles, labels, audiences, tenant rules and capacity care that actually hold under pressure. If you suspect your reports are rumors in a robe, this is your wake-up sermon. Come prepared to repent of manual sharing and leave with a roadmap.

Your “Simple” Excel App Is Quietly Wrecking Your Business (And You Won’t See It Until It’s Expensive) Stop wiring Power Apps into spreadsheets and calling it “production.” Every shared Excel file is a glass elevator: silent data loss, last-save-wins concurrency, and zero governance until an auditor, regulator or angry exec shows up. In this video I tear down the Excel-as-database myth, show why Dataverse is the backbone your apps actually need, and walk you through a 10-step migration plan that keeps the business running while you move. One decision prevents 80% of these failures: centralize your data model, rules, and security in Dataverse first – spreadsheets only get to be views, never the source of truth.

Summary: In this episode I explain why “1,400+ connectors” is a vanity metric and compare Power Automate vs Azure Logic Apps for real enterprise integration. We dig into throttling, throughput, vNet and private endpoints, Azure Arc hybrid, AI agents with Azure Functions, and give you a simple decision rule: Power Automate for departmental M365 convenience, Logic Apps for high-volume, governed, hybrid workloads.

You clicked “Create app from Excel,” felt clever, and accidentally migrated your chaos at scale. In this episode, we break down why Excel is a calculator with delusions of grandeur and why Dataverse will punish spreadsheet habits with integrity errors. I tear down the five silent failure patterns that quietly destroy Power Apps built from Excel data: no primary keys, mixed data types, text lookups instead of real relationships, multipurpose “do everything” columns, and orphan rows that point to nowhere. You’ll hear why identity is a contract, not a column, how surrogate keys and alternate keys stop upserts from behaving like a blender, and how proper types (text, number, decimal, currency, date, choice, lookup, boolean) turn flaky formulas into reliable logic. We’ll walk through replacing VLOOKUP-style thinking with real relationships, splitting overloaded status fields, eliminating orphans with required lookups and cascade rules, and using Power Query to trim, normalize, dedupe, and …

Warehouse Snapshots in Microsoft Fabric promise simplified data recovery and historical consistency — but many organizations misunderstand how they actually work. Snapshots are not traditional backups, and relying on them incorrectly can lead to architectural and governance issues. In this guide, we explain what Microsoft Fabric Warehouse Snapshots really are, how they function within OneLake architecture, and when to use them strategically. You’ll learn about limitations, performance implications, recovery scenarios, and best practices for enterprise data governance. If you’re designing a resilient Fabric architecture, understanding the truth about Warehouse Snapshots is critical.

This episode rips the mask off Microsoft’s new “canvas app revival” story and shows what’s actually happening under the hood. It’s not a renaissance. It’s a fork. A split. A deliberate architectural divide between the fast personal Copilot lane and the governed enterprise Power Platform lane. Across twenty minutes, we expose why App Builder feels familiar on purpose, why that familiarity is a lure, and why defaulting to SharePoint lists is the fastest way to build something that collapses the moment the requirements grow teeth. You’ll hear how delegation limits silently lie to users, how lookup ceilings turn models into spaghetti, and how personal-context inheritance becomes a time bomb the day the creator leaves the company. We walk through the migration cliff, the re-platforming tax, the archaeology required to rebuild a “toy app” into a real system, and why Dataverse isn’t optional once you care about scale, security, or audit trails. From there, the episode pivots into the g…

Worried your SharePoint or Copilot agent is “hallucinating” data leaks? In this episode, we unpack why that’s almost never the model’s fault and almost always your permissions and scope design. You’ll learn how SharePoint and Microsoft 365 agents actually see your data through Microsoft Graph, why overscoped knowledge sources plus permissive inheritance turn into accidental disclosure at machine speed, and why grounding does not equal a security boundary. We break down a practical mental model for agents – user persona plus retrieval filters, gated by permissions, labels, and Purview DLP – and show exactly how an agent can quietly stitch together truths from adjacent libraries you never properly isolated. From there, we go deep into the four control planes that stop bleed without killing usefulness: scoping knowledge sources at the library level with strict metadata and multiple narrow, specialized agents instead of one encyclopedic monster; breaking SharePoint inheritance where it…

Your SharePoint isn’t messy – it’s a digital landfill you’re paying to host. Dead projects, duplicate “final_v7_REAL_final” files, ghost guest access, broken links, and a Copilot happily hallucinating on rotten content. This video shows you how to turn that chaos into a governed, measurable, adult-run SharePoint and Microsoft 365 environment – using licenses you already own. No third-party tools, no fluffy “best practices”, just enforcement. You’ll learn how to stop SharePoint sprawl at the source with standardized site provisioning, templates, and naming that actually stick, then enforce lifecycle with automated inactivity checks, owner attestations, and read-only/archival rules in both E3 and E5. We’ll define what a “healthy” site really is, expose inactive and ownerless sites, cut duplicate content, and reduce search noise so users finally hit the right document on the first click. We go deep on retention labels vs retention policies, how to auto-apply labels using metadata, …

Python is NOT the language of AI inside the Microsoft stack—and in this episode, I show you why that belief is quietly wrecking your Power Platform projects, inflating defects, and burning your budget. If you’re cramming Python into Power Automate, Power BI, Fabric, or custom connectors as “glue code,” this is your wake-up call. We break down why Python is amazing for analytics, ML, and Fabric notebooks—but a terrible choice for everyday orchestration inside Power Automate, Power BI Dataflows Gen2, Dataverse, and Microsoft 365. You’ll learn how Office Scripts (TypeScript-flavoured), Copilot, and agent-style orchestration (like type-agent) can write and run the glue for you, with typed contracts, native connectors, and AI-generated scripts that actually respect your schemas and governance. Instead of debugging brittle Python in Azure Functions at 2:14 a.m., you’ll see how to: Keep Python where it shines: Fabric notebooks, advanced analytics, ML. Use Copilot + Office Scripts to …

SharePoint looks confident on the surface, but under the hood it’s drowning in duplicates, forgotten drafts, and every “final final V2” that ever existed. In this episode, we pull back the curtain on why your search results lie, why Copilot sounds smart while guessing, and how a quiet storm of rogue files destroys governance without anyone noticing. It’s not a storage problem, it’s a relevance problem, and the chaos is baked into human behavior—people hoard because delete feels dangerous. SharePoint obeys, versions multiply, and truth dissolves in a fog of near-identical copies that confuse ranking systems and derail compliance. This episode dives into the architecture that fixes the mess without breaking collaboration or scaring users. We redesign the entire content lifecycle using a SharePoint command, an Azure Function, Blob tiers that behave like a warehouse district, and a ledger that remembers everything you move. Search becomes sharper, Copilot stops hallucinating, and your …

Your Power BI dashboards aren’t broken – you’re just using them for the wrong job. This episode shows why “Export to PDF” is a lying screenshot, and how paginated reports (in the Service, Report Builder, or Visual Studio) finally give executives the print-perfect, audit-ready PDFs they keep asking for. In under half an hour, you’ll learn exactly which tool to pick, how to avoid layout disasters, and a simple upgrade path from “quick hack” to fully governed reporting suite.

You thought VAL vs EXPR was harmless syntax sugar. In reality, it decides when your metrics are evaluated, which means the same function, same arguments can return a completely different “truth” — clean visuals, perfect totals, and numbers that are confidently wrong.