Turn your real-world experience into part of the show.

Microsoft Data Podcast – Analytics, Fabric & Data Governance Episodes

Modern Microsoft architectures are increasingly data-driven, spanning analytics, reporting, automation, and AI workloads. Data Talk focuses on data platforms and governance within the Microsoft ecosystem, including Microsoft Fabric, analytics services, and enterprise data architectures.

Episodes cover topics such as data modeling, pipelines, governance models, security boundaries, and integration with Microsoft 365 and Azure. We explore how data flows across services, where governance breaks down, and why unmanaged growth creates long-term risk.

Data Talk emphasizes understanding data systems as operational platforms rather than isolated analytics tools. Discussions include identity and access models, compliance considerations, data residency, and the interaction between AI-driven services and enterprise data.

This category is intended for data architects, engineers, and IT leaders responsible for designing and governing Microsoft data platforms. If you need clarity on how Microsoft data services behave at scale, Data Talk provides grounded, experience-based insight.

Power by: https://datascience.m365.fm
June 11, 2026

The Latency Wall: Why Your Cloud Strategy Fails at the Edge

Cloud strategies often focus on scalability, cost optimization, and centralized services, but many organizations overlook one critical factor: latency. In this episode of M365 FM, Mirko Peters explores why network latency can become a major barrier to application performance and user experience, especially as businesses increasingly rely on cloud-based services.The discussion examines the concept of the “latency wall” and explains why simply moving workloads to the cloud does not automatically guarantee better performance. For applications that require real-time processing, industrial automation, IoT, AI inference, or low-latency user interactions, the physical distance between users, devices, and cloud datacenters can create significant challenges.The episode highlights how edge computing is emerging as a solution by bringing compute and data processing closer to where data is generated. Rather than sending every request to a centralized cloud region, organizations can levera…
Guest: Mirko Peters
Listen to the Episode
June 5, 2026

How to Bridge the Gap: Connecting Copilot to Predictive Power BI

This episode explores how organizations can connect Microsoft Copilot with the predictive capabilities of Power BI to move beyond simple reporting and toward proactive, data-driven decision-making. The discussion highlights that while Copilot excels at natural language interactions and summarizing information, its real business value increases when it can access trusted analytical models, forecasts, and governed business data from Power BI.The episode explains that many organizations still use Power BI primarily as a dashboard destination. However, the future lies in treating Power BI as a semantic and analytical layer that feeds AI-powered experiences. Instead of navigating reports manually, users can ask questions in natural language through Copilot and receive contextual answers backed by governed Power BI models.A key theme is predictive analytics. By combining Copilot with Power BI datasets, organizations can surface forecasts, trends, risk indicators, and business predic…
Guest: Mirko Peters
Listen to the Episode
May 19, 2026

From DAX to Community: The Power BI Journey with Bernat Agulló Roselló (MVP)

From DAX to Community: The Power BI Journey with Bernat Agulló Roselló explores the evolution of modern Business Intelligence through the personal and professional journey of Microsoft MVP Bernat Agulló Roselló. In this episode of the m365.fm podcast, Bernat shares how he moved from Excel macros and manufacturing reporting into advanced Power BI development, semantic modeling, DAX optimization, and community leadership.The conversation highlights how Business Intelligence is far more than dashboards and visuals. Bernat explains that successful Power BI solutions depend on data modeling, automation, architecture, optimization, and collaboration. A major focus is DAX (Data Analysis Expressions), where he discusses common misconceptions, especially the mistake of treating DAX like Excel formulas. He emphasizes the importance of semantic models, filter context, relationships, and understanding measures versus calculated columns.Another key topic is Tabular Editor and its role in e…
Guests: Mirko Peters, Bernat Agulló Roselló
Listen to the Episode
April 28, 2026

Beyond The Dashboard: How Advanced Sentiment Analysis Redefines Executive Leadership Reporting

The episode argues that traditional dashboards are no longer enough for executive reporting because they only show data, not meaning. Advanced sentiment analysis changes this by capturing how people feel, what’s driving behavior, and where risks or opportunities are emerging.Instead of static KPIs, leadership reporting shifts toward context: why something is happening, who is affected, and what action is required. This enables faster, more informed decisions and reduces the gap between data and real business outcomes.Ultimately, the focus moves from reporting numbers to interpreting signals—turning analytics into a decision system rather than a visibility tool.
Guest: Mirko Peters
Listen to the Episode
April 22, 2026

Your Fabric Bill Is Skyrocketing. And It’s Not The Data.

This episode explains why Microsoft Fabric costs often rise even when data volume stays the same. The key issue isn’t storage—it’s compute behavior. Fabric runs on a shared capacity model where all workloads (reports, pipelines, refreshes, queries) compete for the same resources, so inefficient or poorly timed processes can drive up costs across the entire environment.It breaks down how background activities like scheduled refreshes and pipelines frequently consume capacity before users even start working, creating hidden pressure and performance issues. Because everything draws from one pool, a small number of inefficient workloads can disproportionately impact both cost and performance.The main takeaway: you’re not paying for how much data you store—you’re paying for how your workloads run. To control costs, teams need visibility at the workload level and must optimize how and when compute is used, rather than blaming growth or licensing.
Guest: Mirko Peters
Listen to the Episode
Feb. 24, 2026

How KPI Decision Architecture Turns Dashboards into Real Business Decisions

This episode argues that traditional KPI dashboards fail to drive real organizational action because they focus on visibility instead of decision architecture. Instead of putting all KPIs on one page, leaders need deterministic systems where KPIs encode obligations — clear triggers, ownership, actions, deadlines, and measurable outcomes. Metrics that don’t trigger enforced decisions are not true KPIs. The conversation introduces a decision stack (Data → Logic → State → Action → Interface) and explains how to move from dashboards that show “what happened” to engineered systems that show “what’s already in motion” and enforce execution.
Guest: Mirko Peters
Listen to the Episode
Feb. 7, 2026

Microsoft Fabric Governance Best Practices: Prevent Cost Drift, Governance Theater and Metric Chao

This episode of the M365.FM Podcast explains why Microsoft Fabric governance often fails in real life — even when organizations believe they’ve “solved” governance simply by adopting the platform. The host argues that treating Fabric as a single unified platform with one governance story is a dangerous illusion. Instead, Fabric operates as a composed decision engine with multiple execution paths, shared capacities, and many runtime behaviors that don’t align to org charts or PowerPoint strategies. Common governance efforts — such as naming conventions, Centers of Excellence, and approval workflows — focus on visibility and documentation rather than enforcing actual system constraints. As a result, cost, trust, and meaning quietly decay: costs drift due to shared compute and invisible coupling, workspaces generate entropy when mistaken for control boundaries, and uncontrolled artifacts like semantic models erode metrics and executive confidence. Effective governance in Microsoft Fabric…
Guest: Mirko Peters
Listen to the Episode
Jan. 24, 2026

How to Design Smart Dataverse Models That Scale Low‑Code Business Apps Without Breaking in Production

In this in-depth episode, we reframe how you think about Microsoft Dataverse and the data models that underpin modern business applications. Rather than treating Dataverse as just a database, this conversation argues that your data model is your strategy — and that smart modeling is what separates business solutions that fail quietly from those that scale and adapt sustainably.Inspired by a four-hour deep-dive workshop from Microsoft MVP Bülent Altinsoy, we go beyond low-code app features and instead explore why the underlying model matters more than screens, forms, or workflows. If your team builds solutions with Microsoft Power Platform, Power Apps, Power Automate, or automation agents — this episode will change how you think about modeling data, semantics, relationships, and governance.
Guest: Mirko Peters
Listen to the Episode
Jan. 22, 2026

Architectural Drift in Power BI Fabric: How to Govern Autonomous AI Models and Semantic Models in Microsoft Fabric

In this episode, Architectural Drift: Governing Autonomous AI Models in Power BI Fabric, we explore why modern analytics platforms like Microsoft Fabric and Power BI are not simply reporting tools, but are now part of a broader architectural ecosystem that must be governed to prevent silent semantic drift. Rather than treating Power BI dashboards as the final destination for insights, the episode reframes them as evidence and validation layers within a data ecosystem whose primary interaction surface has shifted upstream. Fabric collapses traditional boundaries between storage, compute, semantic models, publishing, and analytics into a unified environment, which accelerates decision making but also amplifies drift in definitions, metrics, and authority boundaries.As analytic workloads become conversational and AI-enabled, legacy governance assumptions no longer hold. The issue isn’t technical failure but architectural drift—data semantics that once required explicit definition now…
Guest: Mirko Peters
Listen to the Episode
Jan. 20, 2026

Microsoft Fabric Governance Explained: Why Lineage Is Not Real Data Governance (And How To Secure Your Data Control Plane)

Many organizations believe they have governance in Microsoft Fabric because they can see data lineage. In reality, lineage only shows what already happened — it does not prevent anything from happening.This episode explains why Fabric lineage is not governance and why visibility is often mistaken for control. True governance requires a real-time decision engine that can say no before data is accessed, copied, or transformed. Lineage, telemetry, and dashboards are retrospective tools. They describe events after execution, but they do not enforce policy.Microsoft Fabric operates as an execution platform, not as a control plane. It lacks a synchronous policy enforcement point that can block actions at runtime. As a result, many governance assumptions collapse the moment distributed teams, shared workspaces, or cross-domain data flows appear.This episode breaks down where the illusion of control comes from, why it is dangerous, and what real governance actually requires in mod…
Guest: Mirko Peters
Listen to the Episode
Jan. 12, 2026

Why Your Executive Still Ignores Your Power BI Dashboards

Dashboards didn’t fail — they expired.This episode explores why traditional BI reporting stopped being the primary interface for executive decision-making, even when the dashboards are “good.” The problem isn’t visualization quality or adoption. It’s that the business decision model changed, and dashboards didn’t.Executives aren’t asking for numbers anymore. They’re asking for answers: what changed, why it changed, who owns it, and what decisions it affects. Dashboards scale visibility, but they don’t scale judgment. So leadership routes around them—asking humans, or increasingly Copilot—because decision latency matters more than perfect charts.We unpack the hidden assumptions dashboards require (time, shared definitions, stable questions) and why those assumptions collapse in a world of interrupts, drift, and zero patience. Then we trace the interface shift from canvases to intent, where questions become the input and systems must assemble defensible answers with context,…
Guest: Mirko Peters
Listen to the Episode
Jan. 11, 2026

Microsoft Fabric Didn’t Fix Data Engineering – It Exposed It

This episode explores why Microsoft Fabric and Copilot feel empowering and chaotic at the same time. While Fabric simplifies the experience by unifying storage, compute, and analytics into a single platform, it does not remove the hard parts of data engineering. It removes friction, not responsibility. By making it easier to build pipelines, models, and reports quickly, Fabric accelerates every decision, including the wrong or ambiguous ones. Problems that once took months to surface now appear in days or hours, often as rising costs, performance degradation, or dashboards that quietly disagree rather than obvious system failures.The episode explains how older data stacks unintentionally enforced governance through friction. Separate tools, environments, and deployment steps forced teams to define ownership, contracts, and boundaries. Fabric collapses those boundaries into shared workspaces and shared capacity, which blurs accountability and expands the blast radius of mistakes. C…
Guest: Mirko Peters
Listen to the Episode
Jan. 10, 2026

Stop Fixing Bad Data in Power BI – Fix It with T-SQL

Everyone says SQL is obsolete. This episode argues the opposite: SQL has never mattered more—because modern data platforms removed the guardrails that used to hide its importance. In systems like lakehouses and Fabric, T-SQL didn’t disappear; it moved upstream and quietly became the place where cost, security, performance, and truth are either enforced or lost.The episode reframes SQL not as a reporting language, but as a contract language. Without enforced schema, constraints, and predictable execution plans, data systems drift into entropy. Bad data loads successfully, dashboards “fix” it differently, performance becomes unpredictable, and cloud costs spike for reasons no one can explain. These aren’t tooling problems—they’re contract failures.A central theme is execution plans. SQL reads like English but runs like a compiler, and most performance surprises come from misunderstanding how work actually happens. Execution plans aren’t just tuning tools; they’re governance arti…
Guest: Mirko Peters
Listen to the Episode
Dec. 30, 2025

How to Build a Trusted Semantic Layer in Microsoft Fabric

Most organizations think their data problems are about who can see reports. In reality, the bigger risk is what those reports mean today—and how quietly that meaning changes tomorrow. Your transcript argues that Microsoft Fabric doesn’t create chaos by being insecure; it exposes a deeper problem that legacy architectures masked with friction: unmanaged semantic drift.Fabric collapses engineering, analytics, BI, and AI into a single, fast-moving plane. That speed removes the natural brakes that once slowed changes to metrics and models. Teams can clone semantic models, tweak definitions, and publish “truth” in minutes. The result is not broken security—Fabric excels at access control—but broken trust. Revenue, churn, or customer metrics quietly diverge while remaining perfectly secured, audited, and compliant.The core insight is the separation of three layers often blurred into “governance”: platform security, data governance, and semantic governance. Microsoft largely solves t…
Guest: Mirko Peters
Listen to the Episode
Dec. 27, 2025

The Hidden Cost of Duplicate Customers in Power BI

The system never betrayed your data — it only obeyed it. The real problem begins the moment identity is treated as an assumption instead of a constraint. What looks like harmless flexibility at small scale quietly turns into structural uncertainty as data grows, sources multiply, and systems change. Business keys such as emails, customer IDs, or composite identifiers were never identities; they are temporary labels tied to applications, policies, and human discipline. Once those labels leave their original systems, they decay. Duplicates become legal, conflicts accumulate, and ambiguity spreads through every join, aggregation, dashboard, and AI model. Nothing crashes, nothing alerts, and yet decisions drift further from reality. Attempts to repair this at the pipeline, notebook, or semantic layer only mask the problem, because application logic cannot survive concurrency, replay, or evolution. In distributed platforms, entropy is not an exception — it is the default state. True stabil…
Guest: Mirko Peters
Listen to the Episode
Dec. 19, 2025

How to Build a Bronze–Silver–Gold Data Pipeline in Fabric

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…
Guest: Mirko Peters
Listen to the Episode
Dec. 14, 2025

How to Fix Bad Power BI Themes That Hide Your Data

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.
Guest: Mirko Peters
Listen to the Episode
Dec. 6, 2025

How to Kill Data Silos with Microsoft Fabric and OneLake

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.
Guest: Mirko Peters
Listen to the Episode
Dec. 1, 2025

How to Stop Stale Power BI Reports from Misleading Leaders

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.
Guest: Mirko Peters
Listen to the Episode
Nov. 30, 2025

Why Serious Power Apps Should Never Run on Excel Files

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.
Guest: Mirko Peters
Listen to the Episode
Nov. 27, 2025

Power Automate vs Azure Logic Apps: Which is better for enterprise?

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.
Guest: Mirko Peters
Listen to the Episode
Nov. 25, 2025

Data Team Drowning in „Which Number Is Right?“ Debates? Lock Baselines in Fabric

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.
Guest: Mirko Peters
Listen to the Episode
Nov. 22, 2025

Azure Functions + Python: The Cost Trap Killing Your Power Platform ROI

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 …
Guest: Mirko Peters
Listen to the Episode
Nov. 19, 2025

How to Choose the Right Paginated Tool: Service vs Report Builder vs SSRS

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.
Guest: Mirko Peters
Listen to the Episode