Got ideas about Microsoft 365? Want your own episode? → come build this with me on LinkedIn

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.
Business Users Still Waiting Days for Reports? Fix It With Copilot Studio
Nov. 5, 2025

Business Users Still Waiting Days for Reports? Fix It With Copilot Studio

Your company isn’t blocked by data—it’s blocked by syntax.Copilot Studio turns plain-English questions into governed Fabric queries, so “What was our revenue by quarter?” finally gets an instant, secure answer—no SQL, no tickets, no waiting. It’s not a chatbot; it’s a translation engine that reme…
Guest: Mirko Peters
Your Power BI Model Looks Fine but Your Queries Are Breaking It
Nov. 5, 2025

Your Power BI Model Looks Fine but Your Queries Are Breaking It

Power BI is lying to you.Those neat, orderly “Applied Steps” you trust are a façade.Power Query is secretly rearranging, deferring, collapsing and sometimes ignoring the way you wrote your transform steps — which is why your filters don’t filter, your merges get weird, and refreshes suddenly go…
Guest: Mirko Peters
Copilot shows wrong numbers? Fix your Fabric data model now
Nov. 4, 2025

Copilot shows wrong numbers? Fix your Fabric data model now

Copilot didn’t hallucinate — you hallucinated first.Your schema lied → Fabric believed it → Copilot repeated it with confidence.Bad Bronze → leaky Silver → fake Gold = executive decisions built on fiction.Fix the Medallion discipline + fix the semantic layer — or keep paying for an AI that po…
Guest: Mirko Peters
Why Your Power BI Dashboards Don’t Change Any Decisions
Nov. 4, 2025

Why Your Power BI Dashboards Don’t Change Any Decisions

Power BI isn’t failing because of visuals — it’s failing because nobody plans. 60–70% of BI projects become expensive wallpaper. This episode exposes the 3 discipline steps that separate strategic intelligence from dashboard vanity — why most organizations confuse activity for progress, and how to …
Guest: Mirko Peters
Power BI Governance 101: Build One Single Source of Truth
Nov. 3, 2025

Power BI Governance 101: Build One Single Source of Truth

Power BI Collaboration — from Wild West → Hub-and-SpokePower BI self-service feels empowering… until every department defines “revenue” differently and no one agrees which dashboard is real. In this episode, we break down why the chaos isn’t a tooling problem — it’s an architecture problem — an…
Guest: Mirko Peters
Dataverse Is Not Free: How to Avoid the Power Apps License Trap
Nov. 2, 2025

Dataverse Is Not Free: How to Avoid the Power Apps License Trap

Dataverse isn’t “included.” It’s a premium, enterprise-grade platform with costs that stack fast: licenses, capacity, environments, storage (db/file/log), and API limits. Most sticker shock comes from assumptions—thinking M365 covers Dataverse, that guests are free, or that storage is cheap.Use…
Guest: Mirko Peters
Why Your Fabric Dataflows Are Burning Compute for Nothing
Nov. 1, 2025

Why Your Fabric Dataflows Are Burning Compute for Nothing

Most Microsoft Fabric teams are bleeding money because they treat Dataflows Gen2 like old Power BI ETL. In Fabric, compute—not storage—is the meter, so every redundant refresh spins up clusters, reloads the same sources, and multiplies cost. The fix is architectural, not heroic CSV exports.Ther…
Guest: Mirko Peters
Drowning in CSVs for Audits? Automate Fabric Governance with GPT‑5
Nov. 1, 2025

Drowning in CSVs for Audits? Automate Fabric Governance with GPT‑5

Fabric didn’t fail at features—it failed at governance cohesion. Data lives in Fabric, security sits in Power BI, labels live in Purview—and they don’t natively reason about each other. That’s why audits devolve into CSV marathons and name-matching nightmares.Enter GPT-5 inside Microsoft 365 Co…
Guest: Mirko Peters
Your Power BI Numbers Are Wrong Because of Excel – Fix the Data with Copilot
Oct. 30, 2025

Your Power BI Numbers Are Wrong Because of Excel – Fix the Data with Copilot

Most “analysis” in Excel is disguised janitorial work: inconsistent dates, mixed data types, rogue spaces, and copy-pasted chaos that later poisons Power BI, Power Automate, and Fabric. The fix isn’t heroics—it’s Excel Copilot acting as an AI janitor that understands structure, enforces types, and …
Guest: Mirko Peters
SharePoint Governance Fail: Why Your Power Apps Are Out of Control
Oct. 23, 2025

SharePoint Governance Fail: Why Your Power Apps Are Out of Control

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 collapses quietly: no environment isolation, i…
Guest: Mirko Peters
Your Fabric Lakehouse Is I/O Bound, Not CPU Bound – Here’s the Fix
Oct. 22, 2025

Your Fabric Lakehouse Is I/O Bound, Not CPU Bound – Here’s the Fix

Your Fabric and Power Platform workloads aren’t slow because of Spark or DAX—they’re slow because your data lives far from your compute. Managed storage adds network hops, caps IOPS, and taxes every read/write with latency. The fix isn’t “more nodes”; it’s proximity. Azure Container Storage v2 (ACS…
Guest: Mirko Peters
Dataverse Role Mistakes That Let Partners Download Your Customer List
Oct. 20, 2025

Dataverse Role Mistakes That Let Partners Download Your Customer List

Your Power App didn’t get “hacked”—it was over-permitted. Treating Dataverse like SharePoint (big buckets, broad roles) turns guest access into a data breach waiting to happen. Dataverse is a relational fortress built on granular privileges (Create/Read/Write/Delete/Append/Append To/Assign/Share), …
Guest: Mirko Peters
Before You Buy Power BI Premium, Fix This Data Model Problem
Oct. 20, 2025

Before You Buy Power BI Premium, Fix This Data Model Problem

Your dashboards aren’t just slow—they’re expensive. Every bloated column, lazy import, and tangled relationship silently taxes your Power BI Premium capacity and your team’s time. That inefficiency adds up to real money—often five figures a year. The cure isn’t a plug-in; it’s architecture. Move fr…
Guest: Mirko Peters
Stop Treating AI Like an App: How to Design It for GPUs and Data
Oct. 16, 2025

Stop Treating AI Like an App: How to Design It for GPUs and Data

AI is not “just another app” you park on general-purpose servers. Enterprise AI behaves like an ecosystem — volatile workloads, bursty data, exotic compute, and constant model evolution. That’s why so many AI pilots glow in the lab then die in production. The five tells that you’re no longer dealin…
Guest: Mirko Peters
Power BI Refresh Taking Hours? Switch to Direct Lake in OneLake
Oct. 11, 2025

Power BI Refresh Taking Hours? Switch to Direct Lake in OneLake

Microsoft Fabric fundamentally changes how Power BI handles data. With OneLake and Direct Lake, Power BI can now query lakehouse tables directly with performance similar to Import mode — without creating duplicate copies or maintaining complex refresh cycles.The winning Fabric pattern is simple…
Guest: Mirko Peters
7 Sales Pipeline Mistakes That Make Good Leads Go Cold
Oct. 8, 2025

7 Sales Pipeline Mistakes That Make Good Leads Go Cold

In a recent podcast, Mirko Peters discussed the challenges of choosing between Synapse Link and Dataflow Gen 2 for Dataverse pipelines, emphasizing the importance of making informed decisions to avoid project failures. The conversation highlighted issues that arise when multiple teams create overla…
Guest: Mirko Peters
Stop Clicking 500 Times: Bulk Rename Power BI Measures with PBIP
Oct. 6, 2025

Stop Clicking 500 Times: Bulk Rename Power BI Measures with PBIP

In this episode, we dive into how to replace measures in Power BI using DAX, helping you simplify your data model, improve report performance, and create more accurate, maintainable calculations. We explain what measures are, why they’re essential for interactive Power BI reports, and how they diff…
Guest: Mirko Peters
How to Audit Power BI Semantic Models and Slash Capacity Spend
Oct. 5, 2025

How to Audit Power BI Semantic Models and Slash Capacity Spend

In this episode, we break down Microsoft Power BI’s pricing structure to help you understand the different license options, costs, and features available across the Power BI ecosystem. Whether you're comparing Power BI Free, Pro, Premium Per User, or Premium Per Capacity, this guide gives you a cle…
Guest: Mirko Peters
Power BI vs Spreadsheets: When Dashboards Actually Win
Oct. 4, 2025

Power BI vs Spreadsheets: When Dashboards Actually Win

In this episode, we explore how Power BI and Microsoft Teams work together to create a seamless, collaborative analytics experience. We break down how Power BI’s powerful data visualization capabilities integrate directly into Microsoft Teams, allowing organizations to share insights, discuss repor…
Guest: Mirko Peters
Microsoft Fabric for BI Teams: Get One Trusted Dataset for All Dashboards
Oct. 3, 2025

Microsoft Fabric for BI Teams: Get One Trusted Dataset for All Dashboards

In this episode, we dive into Microsoft Fabric, the unified data and analytics platform reshaping how organizations manage, analyze, and act on their data. Designed to bring Power BI, Data Factory, Azure Synapse, and other Microsoft services into one integrated environment, Fabric simplifies everyt…
Guest: Mirko Peters
How to Stop R Freezing When You Pull Millions of Rows from SQL
Oct. 1, 2025

How to Stop R Freezing When You Pull Millions of Rows from SQL

In this episode, we dive into how R and SQL Server work together to create a powerful data analytics workflow. You’ll learn why SQL Server excels at storing, organizing, and retrieving large datasets, while R specializes in statistical analysis, visualization, and machine learning. When combined, t…
Guest: Mirko Peters
Dynamics 365 Business Central Telemetry: Understanding and Setup
Sept. 30, 2025

Dynamics 365 Business Central Telemetry: Understanding and Setup

In this episode, we explore how organizations can turn Dynamics 365 Business Central telemetry into powerful insights using Microsoft Power BI. Telemetry is one of the most valuable—and often underused—capabilities in Business Central. It captures performance data, user behavior, errors, and system…
Guest: Mirko Peters
Is Your Dataflow Reusable—or a One-Trick Disaster?
Sept. 29, 2025

Is Your Dataflow Reusable—or a One-Trick Disaster?

In this episode, we dive into one of the core engines behind Microsoft Fabric’s modern analytics ecosystem—Dataflows Gen2. We explore how this next-generation data ingestion and transformation tool is shaping the way organizations prepare, refine, and deliver data for analytics.We start with an…
Guest: Mirko Peters
Microsoft Fabric Digital Twin Explained: Fix for Messy Data or Overhyped Feature?
Sept. 28, 2025

Microsoft Fabric Digital Twin Explained: Fix for Messy Data or Overhyped Feature?

In the evolving world of Microsoft Fabric, the Digital Twin Builder preview emerges like a quiet shift that changes everything without announcing itself loudly. You start by taking the world you already know—machines, rooms, sensors, movements, transactions—and giving it a second life inside the Fa…
Guest: Mirko Peters