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
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 everything from data ingestion and transformation to advanced analytics and real-time reporting.You’ll learn what Microsoft Fabric is, why analytics play a central role in modern data platforms, and how Fabric creates a single source of truth across your organization. We break down the major components—Fabric Data Warehouse, Data Factory, data engineering tools, SQL capabilities, data science workflows, and seamless Power BI integration. These features enable businesses to build scalable data pipelines, perform complex analytics, and visualize insights effortlessly.The episode explains how Fabric enhances Power BI through real-time analytics, unified data access, and deeper integration wit…
Guest: Mirko Peters
Listen to the Episode
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, these two tools streamline data processing, reduce duplication of effort, and enable deeper, more efficient data insights.We explore common use cases—such as running SQL queries from R, analyzing SQL Server data with R’s statistical packages, and using R to create visualizations or predictive models based on SQL data. The episode also walks through how to set up your environment, install the required R packages (RODBC, DBI, odbc, sqldf), and configure ODBC connections so R can query SQL Server directly.You’ll learn best practices for writing SQL queries inside R scripts, using T-SQL features, fetching data into R data frames, and mapping R data types to SQL Server types without losing…
Guest: Mirko Peters
Listen to the Episode
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 activity, giving administrators a complete view of how their environment is running.We begin by breaking down what Business Central telemetry is, why it matters, and how it helps companies identify performance issues, track usage, and optimize their configurations. The episode explains how telemetry is collected through Azure Application Insights and what kinds of data Business Central emits—everything from page views and API calls to background sessions and extension behavior.Listeners learn the practical steps for enabling telemetry in the Business Central admin center and how Azure Application Insights becomes the hub for querying, monitoring, and alerting on system activity. We …
Guest: Mirko Peters
Listen to the Episode
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 overview of Microsoft Fabric, Microsoft’s unified analytics platform that brings together data engineering, data science, real-time analytics, Power BI, data factory, and lakehouse capabilities in a single integrated environment. Fabric is designed to simplify complex data estates, and Dataflows Gen2 plays a pivotal role in achieving that simplicity.Listeners get a clear explanation of what Gen2 actually means: improved architecture, better performance, expanded connectivity, stronger data prep features, and support for more complex data ingestion scenarios. Gen2 builds on traditional Power Query–based dataflows but offers scalability and reliability fit for enterprise-grade pipelines.…
Guest: Mirko Peters
Listen to the Episode
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 Fabric environment. This second life isn’t static or symbolic; it breathes with real-time data, always adjusting, always reflecting what’s happening right now. Data from sensors, logs, or operational systems flows into the Fabric lakehouse, and the builder reshapes it into a digital form that mirrors the physical world. The semantic canvas becomes the place where these connections come alive, letting you see how everything relates, how one action affects another, and how the digital counterpart shifts as the real world does. You wire event streams into the model, and suddenly the quiet digital structure begins to pulse with updates—temperature changes, equipment activity, stock movement, envir…
Guest: Mirko Peters
Listen to the Episode
Sept. 26, 2025

Power BI Version Control & Collaboration: GitHub, CI/CD & Best Practices

power bi keeps showing up in the background of every conversation about data because it does something most tools struggle with: it doesn’t just help you look at numbers, it helps people work together around them. the reports, the dashboards, the visuals—those are great, but the real power is how easily a team can gather around the same set of insights without fighting through email attachments or version chaos.you start with data from wherever it lives, pull it into power bi, shape it, build something that actually makes sense. but the magic happens the moment you hit share. suddenly the report isn’t just yours; it becomes something the whole team can poke at, question, filter, and react to. in the service, everything lives in the cloud, so no one needs to hunt for the right file or worry about sending the wrong version. everything updates in place. everyone sees the latest truth.workspaces add another layer, turning what used to be a solo project into a team studio. people c…
Guest: Mirko Peters
Listen to the Episode
Sept. 26, 2025

Power BI Star Schema: The Pro Trick No One Teaches (Data Modeling Secrets)

when people first open power bi, they usually jump straight into visuals. charts, slicers, maps—it feels like that’s where the real action is. but the longer you work with it, the more you realize that the real magic is happening underneath, in the way the data is shaped and modeled. the model is the engine, and without the right engine, even the best-looking report falls apart. that’s where the star schema comes in. it’s the moment power bi stops feeling confusing and starts making sense.think of power bi desktop as the workshop. it brings in data from wherever it lives, lets you clean it up with power query, and gives you a canvas to shape how everything relates. but the trick isn’t just getting the data in—it’s organizing it so power bi can think clearly. when you structure your data in a star schema, something clicks. suddenly measures work the way you expect. filters behave predictably. visuals respond faster. and the model becomes easy to explain to anyone, even people who’v…
Guest: Mirko Peters
Listen to the Episode
Sept. 25, 2025

Power BI Alerts vs Fabric Data Activator: Key Differences Explained

the moment people hear “data activator,” they assume it’s just another automation tool tucked somewhere inside microsoft fabric. but once you actually see it in action, it feels more like watching data wake up. instead of dashboards that wait for someone to notice a problem, the activator notices it for you. instead of a report that quietly updates in the background, the activator jumps in and does something the second a condition is met. it turns fabric from a place where you look at data into a place where data reacts, nudges, alerts, and responds.the idea behind it is simple: anything that changes in your data—anything that spikes, drops, drifts, or falls out of pattern—can automatically trigger an action. and the best part is that you don’t need code to make any of this happen. the activator listens to your streams from power bi, event hubs, and other sources, and you just tell it what to look for. when the pattern appears, the action fires. maybe it’s a teams message. maybe i…
Guest: Mirko Peters
Listen to the Episode
Sept. 25, 2025

Power BI Deployment: How to Do It Like a Pro (No More Guesswork)

every organization that takes data seriously eventually hits the same crossroads: the reports are getting bigger, the models are getting more complex, more people are asking for changes, and suddenly a single workspace with everyone pressing publish just doesn’t work anymore. this is usually the moment someone brings up deployment pipelines in power bi, and the whole process of managing reports starts to feel less like chaos and more like an actual system.the concept is simple enough. instead of pushing everything straight into production, you move through stages. you build in one place, you test in another, and only when you’re ready do you send it to the environment where everyone depends on it. but the moment you start using deployment pipelines, you realize it’s not just about structure—it’s about control, quality, and avoiding the kind of mistakes that ripple across a whole organization because someone replaced a measure at the wrong time of day.what makes pipelines feel …
Guest: Mirko Peters
Listen to the Episode
Sept. 24, 2025

T-SQL vs SQL: How T-SQL Eliminates IT Bottlenecks

people often hear the words sql and t-sql thrown around as if they’re interchangeable, and for a while they feel like they are. you write a query, you get your results, and everything seems straightforward. but the deeper you go into database work, the more you notice that not all sql behaves the same, and the moment you start working with microsoft sql server or azure sql, t-sql shows up and quietly becomes its own world. and suddenly the differences matter—not because they’re confusing, but because they’re the key to building things that are faster, safer, and smarter.sql itself is the foundation. it’s the shared language every relational database speaks, the set of rules for selecting data, joining tables, filtering results, and reshaping information. it’s the common grammar behind mysql, oracle, postgresql, and sql server. if sql were a language like english, the basic structure would always be the same everywhere you go.t-sql is what happens when microsoft adds its own di…
Guest: Mirko Peters
Listen to the Episode
Sept. 24, 2025

How Power BI Turns SharePoint Chaos Into Clarity

sharepoint has this way of becoming everything and nothing all at once. a place meant for structure slowly turning into a maze of lists, libraries, document versions, old folders nobody remembers creating, and columns added by someone who left the company four years ago. people rely on it because it’s everywhere, because it’s part of microsoft 365, because it’s the easiest place to drop things when you don’t know where else they go. but with enough time, the whole thing starts to feel like a storage closet that everyone uses and nobody organizes.and then power bi steps in—not as a cleanup crew, but like someone who can walk into that same chaotic room and immediately understand where everything belongs. power bi doesn’t care how messy the source looks. as long as it can connect, it can make sense of it. once you point it at a sharepoint site, especially one running on sharepoint online, it starts reading those lists and libraries for what they really are: structured data waiting t…
Guest: Mirko Peters
Listen to the Episode
Sept. 23, 2025

Dataverse Migration: Why Every Power Platform Eventually Hits This Wall

This episode cuts through the confusion around Dataverse data migration and explains, in plain language, how to move data between environments without breaking your schema, losing your relationships, or waking up to a support queue full of duplicate records. You’ll hear why data migration has quietly become one of the most essential skills for Power Platform teams, and how the right mix of tools—Configuration Migration Tool, dataflows, Power Automate, and the broader Power Platform stack—turns a painful, error-prone process into a predictable, governed pipeline.We start by grounding everything in what Dataverse actually is: not just tables and rows, but a secure, relational, cloud-first data backbone built around business logic, unique identifiers, and strict data integrity rules. From there the episode dives into the real decisions teams face when migrating—how configuration data behaves differently from transactional data, why alternate keys matter more than people assume, and h…
Guest: Mirko Peters
Listen to the Episode
Sept. 22, 2025

Why Copilot Fails: The Data Quality Problem Nobody Talks About

This episode goes straight into the uncomfortable truth behind Microsoft Copilot: the same AI that accelerates your workflows can also expose your most sensitive data if you don’t govern it correctly. We unpack how Copilot for Microsoft 365 pulls information from across SharePoint, OneDrive, Teams, and the Microsoft Graph, and why that deep integration becomes a double-edged sword the moment your permissions, classifications, or data boundaries fall even slightly out of alignment.You’ll hear how real data leaks happen—not through hacking, but through perfectly normal Copilot behavior. Meeting summaries pulling restricted content. Auto-generated documents mixing in confidential details. Presentations created from SharePoint libraries the user shouldn’t have access to in the first place. We break down why Copilot doesn’t “invent” exposure, it amplifies whatever access model your tenant already has, for better or worse.From there, the episode zooms out to the bigger issue: modern…
Guest: Mirko Peters
Listen to the Episode
Sept. 20, 2025

I Thought My Power BI Gateway Was Fine… Until Everything Broke

Power BI Gateway is the secret weapon that makes it possible to bring secure, on-premises data into the cloud power of Microsoft Power BI without moving anything outside your firewall. In this episode, we break down how the on-premises data gateway works, why organizations rely on it, and how it seamlessly connects local SQL servers, file shares, and other internal data sources to the Power BI service. You’ll learn what the gateway actually is, the difference between the standard gateway and personal mode, how the architecture uses Azure Service Bus to securely transfer data, and how to install, configure, and manage a gateway for reliable data refresh and reporting. We also dive into connecting Power BI Desktop to on-premises systems, publishing reports that stay synced through scheduled refresh, and optimizing gateway performance with best practices and modern options like the Virtual Network Data Gateway. If you’ve ever wondered how Power BI can access protected on-prem data withou…
Guest: Mirko Peters
Listen to the Episode
Sept. 18, 2025

Microsoft Fabric Domains: Why They Don’t Fix Your Governance Problem

Microsoft Fabric domains are quickly becoming one of the most important pillars of governance and organization inside the Fabric ecosystem, and in this episode we break down exactly how they work and why they matter. You’ll learn how domains create logical groupings of workspaces and data assets, how they support a true data mesh architecture, and how they give organizations a clean, scalable way to manage ownership, access, and compliance across business units. We explore how Fabric domains tie into tenant-level governance, how domain admins and contributors manage their own data products, and how tools like the Purview-powered data map and OneLake help organizations discover, classify, and govern data across every domain. You’ll also see how Power BI fits into the model, how to plan domain structures effectively, how to avoid common pitfalls like inconsistent workspace organization, and what future governance trends are emerging as Fabric evolves. If you want to understand how Fabri…
Guest: Mirko Peters
Listen to the Episode
Sept. 18, 2025

LINQ to SQL: Magic or Mayhem?

LINQ to SQL remains one of the most approachable ways to query and manipulate relational data in .NET, and in this episode we break down exactly how it works, why it’s so powerful, and how it simplifies database interaction compared to traditional SQL and ADO.NET patterns. You’ll learn how LINQ to SQL bridges object-oriented programming with relational data, how Data Contexts map directly to your database schema, and how LINQ expressions are translated into real SQL queries executed by SQL Server. We explore everything from basic selects and filters to advanced joins, grouping, updates, inserts, deletes, and even calling stored procedures through strongly typed methods. You’ll also see how LINQ to SQL compares to LINQ to Objects, how it integrates with the .NET runtime, and how it improves readability, type safety, and maintainability across your entire data access layer. If you want a clear, modern, developer-friendly path to querying databases in C# without manually writing SQL ever…
Guest: Mirko Peters
Listen to the Episode
Sept. 11, 2025

Microsoft Fabric Changes Everything for BI Pros (Here’s Why)

This episode explains how Microsoft Fabric can significantly elevate the work of Power BI professionals by unifying data engineering, governance, storage, and analytics into one platform. It shows how Fabric enhances existing Power BI workflows without forcing teams to redo their reports or models.You’ll learn what Fabric means for your current Power BI environment, how it fits into Microsoft’s roadmap, and how it can impact your career. The episode includes practical migration guidance, tips for preserving datasets and semantic models, and warnings about common performance traps. It also walks through live demo scenarios such as creating a Lakehouse-backed semantic model and scaling it for enterprise use.Key topics include centralized governance, lineage, compliance, and realistic discussions about cost and scaling — including when Fabric can save money and when it may not. Listeners leave with a clear evaluation checklist, a modernization plan, stakeholder talking points, an…
Guest: Mirko Peters
Listen to the Episode
Aug. 17, 2025

Microsoft Fabric Dataflows Gen2: The Future of ETL Explained

Fabric Dataflows Gen2 redefine how ETL processes are built and managed inside Microsoft Fabric. Unlike legacy Power BI Dataflows, Gen2 introduces scalable, reusable, and Lakehouse-integrated data transformation capabilities designed for enterprise-grade analytics environments.In this guide, we explain how Fabric Dataflows Gen2 work, how they integrate with OneLake and Lakehouse architecture, and when to use them instead of pipelines or notebooks. Whether you're modernizing your ETL strategy or building a new Fabric-based data platform, this breakdown helps you understand the architectural impact and governance considerations of Gen2 Dataflows.If you're building scalable, maintainable ETL inside Microsoft Fabric — this is essential reading.
Guest: Mirko Peters
Listen to the Episode
Aug. 16, 2025

Dynamics 365 Embedded Analytics with Power BI & Fabric Explained

Stop exporting Dynamics 365 data to Excel. Connect Dataverse to Microsoft Fabric, build an analytics model once, and embed Power BI directly inside Dynamics 365 (CRM/ERP) screens. With live, role-aware metrics (RLS), sales and ops teams act on fresh data without tab-switching, stale snapshots, or version drift. Use Fabric Data Factory/Dataflows Gen2 to shape data, enforce security with Entra ID and sensitivity labels, and place context-specific visuals in forms and dashboards. Result: faster decisions, fewer reconciliations, and a proactive, in-app analytics loop.
Guest: Mirko Peters
Listen to the Episode
Aug. 16, 2025

Microsoft Fabric Lakehouse Governance & Data Lineage Explained

Stop guessing where your data went. In Microsoft Fabric, automatic lineage, workspace-based permissions, and Purview’s enterprise catalog turn opaque pipelines into auditable, end-to-end flows—from ingestion to transformation to the report. Fabric captures every hop (Data Factory, Lakehouse, notebooks/SQL/Dataflows, semantic models, Power BI), enforces access consistently via workspace inheritance, and records who changed what and when. With Purview cataloging and classifications on top, you can search sensitive fields across workspaces, prove compliance with unified audit logs, and fix broken KPIs fast—without chasing email threads or exporting mystery CSVs.
Guest: Mirko Peters
Listen to the Episode
Aug. 15, 2025

Microsoft Fabric Data Activator: Real-Time AI Insights & Automation Explained

Stop waiting on dashboards. Fabric Data Activator turns live signals into instant actions—pausing bad pipelines, placing purchase orders, opening D365 work orders, or triggering API calls the moment thresholds hit. Because it’s native to Microsoft Fabric, it listens to streams and models from Power BI, Synapse, and the Lakehouse, then executes pre-approved playbooks with minimal latency. Start small with high-value triggers, design for capacity and downstream SLAs, and wire in guardrails so you get signal—not alert spam. That’s how you move from data-driven to data-activated.
Guest: Mirko Peters
Listen to the Episode
Aug. 14, 2025

Microsoft Fabric Notebooks: AI Model Training Explained

Stop torturing your laptop. Train models where the data lives. With Microsoft Fabric notebooks running on Spark next to your Lakehouse, you skip CSV exports, move terabytes at query speed, and iterate in Python or R without memory crashes. Push transforms to the data, engineer features at scale, monitor long runs in real time, checkpoint models, and evaluate across massive test sets—cutting days of wrangling into hours of results.
Guest: Mirko Peters
Listen to the Episode
Aug. 14, 2025

Dataverse Data Modeling: How to Design Scalable Data Models

Dataverse “slowness” is often schema, not size. Fix table bloat, simplify relationships, and add the right indexes to turn crawling forms and timing-out flows into crisp responses. Design for performance from day one—balance normalization, limit cascades, and index what you filter on.
Guest: Mirko Peters
Listen to the Episode
Aug. 13, 2025

Integrating Dynamics 365 Sales with Microsoft Teams: CRM Data in the Flow of Work

Stop context-switching. Embed Dynamics 365 Sales directly into Microsoft Teams so reps update opportunities, trigger approvals, and log notes where they already work. Layer Power Automate and Adaptive Cards to turn chats into actions (create/update/approve) and keep CRM as the single source of truth. Result: faster deal cycles, cleaner data, fewer misses.
Guest: Mirko Peters
Listen to the Episode