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
Aug. 12, 2025

Building Reusable Semantic Models in Microsoft Fabric: Scalable Power BI Architecture & Governance

Most Power BI environments start fast and stall under copy-paste sprawl: duplicated PBIX files, conflicting measures, and “spreadmart” dashboards that nobody fully trusts. The fix isn’t another naming convention—it’s a model-first architecture. Microsoft Fabric elevates the semantic model to an enterprise asset: one definitional layer reused across reports, workspaces, and teams. Pair that with calculation groups to eliminate endless YTD/QTD/TTM variants and keep time intelligence, KPIs, and business rules centralized and auditable. Add row-level security in the model to deliver true governed self-service—users explore freely while access is enforced automatically by role and region. The result: fewer datasets, consistent metrics, faster updates, and a BI stack that scales without chaos. If you’re tired of DAX drift and number debates, Fabric’s semantic models + calc groups + RLS turn scattered reports into a trustworthy analytics backbone.
Guest: Mirko Peters
Listen to the Episode
Aug. 12, 2025

Microsoft Fabric Lakehouse Performance: How to Optimize Queries, Pipelines & Data Models

Microsoft Fabric Lakehouse environments enable unified analytics across structured and unstructured data — but performance optimization is critical to ensure scalability, cost control, and reliable reporting.In this guide, we break down how to optimize Lakehouse performance in Microsoft Fabric, including data modeling strategies, partitioning best practices, query tuning, workload management, and storage optimization. Whether you're working with large datasets, real-time analytics, or enterprise reporting, these practical recommendations help you prevent bottlenecks and improve overall system efficiency.If your Fabric Lakehouse feels slow, unpredictable, or expensive — this is where to start.
Guest: Mirko Peters
Listen to the Episode
Aug. 10, 2025

How to Secure Microsoft Fabric Data Pipelines (Avoid Data Leaks & Access Risks)

Microsoft Fabric pipelines often feel “secure by default,” but silent data exposure usually comes from misconfigured permissions, hardcoded secrets, and overbroad workspace roles. This episode shows how to harden end-to-end pipelines with managed identities (kill passwords), Azure Key Vault (centralize and audit secrets), and precise RBAC (least privilege at workspace, pipeline, and dataset layers). You’ll learn where Fabric inherits risky defaults, how tenant/workspace access quietly widens, and the exact steps to lock down connectors, notebooks, and pipelines—without slowing your teams. Walk away with a practical security playbook, audit-ready logging, and guardrails that let admins, analysts, and engineers move faster with less risk.
Guest: Mirko Peters
Listen to the Episode
Aug. 10, 2025

Why Your Power Apps Break (And How Automated Testing Fixes It)

Low-code does not mean low risk. Power Apps and Dataverse sit at the center of many business-critical processes, so skipped testing leads to silent data loss, broken approvals, and security leaks. This episode shows how to build a real testing strategy for the Power Platform: automate end-to-end scenarios across roles and environments, validate Dataverse business rules and flows, and wire tests into CI/CD with tools like EasyRepro and the Power Platform CLI. Learn why manual UAT misses dynamic UI, security role differences, environment variables, and connector drift—and how automated tests catch them before production. Walk away with a practical framework, checklists, and KPIs to accelerate delivery while protecting data quality, compliance, and trust.
Guest: Mirko Peters
Listen to the Episode
Aug. 10, 2025

Fix Microsoft Fabric Git Integration Issues: Version Control and Sync for Notebooks Explained

Microsoft Fabric’s Git integration isn’t a backup—it’s the backbone of safe, scalable collaboration on notebooks, pipelines, and models. This guide explains why merge chaos happens, what actually syncs to Git (code/metadata) vs. what doesn’t (Lakehouse data), and the one switch that saves teams: adopt a simple dev→test→prod branching model with pull requests. You’ll get a practical playbook to connect workspaces, resolve conflicts, manage environment configs, and keep data parity—so rollbacks are one click, not a week of rework.
Guest: Mirko Peters
Listen to the Episode
Aug. 9, 2025

Fabric Notebooks for Data Transformation and ML

Stop wrestling Power BI with endless clicks. Microsoft Fabric Notebooks let you prep, model, and feature-engineer data end-to-end—in Python or R—right inside your Lakehouse with Spark scale and Git governance. This guide shows a proven workflow: ingest to Bronze, clean and join to Silver, feature-engineer to Gold, and publish to Power BI or ML—all from one notebook. Learn the overlooked switch pros miss: treat notebooks as your single source of truth (code-first, Git-backed, env-parametrized), not as ad-hoc helpers. You’ll get patterns for data lineage, environment configs, access control, and can’t-miss guardrails (snapshots, canary checks, idempotent writes) so rollbacks are painless and dashboards stay accurate.
Listen to the Episode
Aug. 8, 2025

Extending Microsoft Fabric with Custom APIs and Power BI Models

Fabric’s UI is great for quick wins—but it hits limits with niche data sources, complex business logic, and real-time automation. The way through is building custom API integrations (secure, least-privilege, monitored) and surfacing them with Power BI semantic models (single source of truth, governed measures, embedded where people work). The result: live, cross-system analytics without manual exports, brittle hacks, or stale dashboards.
Listen to the Episode
Aug. 8, 2025

Building Customer Portals with Power Pages + Dataverse

Stop emailing Dataverse exports. Build a branded, secure, customer-ready portal with Power Pages that shows the right records to the right people—nothing more. This guide gives you a step-by-step build, least-privilege web roles/table permissions, and a go-live checklist (auth, data scope, branding, audit) so your CISO sleeps and your users stop chasing spreadsheets.
Listen to the Episode
Aug. 8, 2025

Building Machine Learning Models in Microsoft Fabric

Ship ML faster on Microsoft Fabric. This guide shows how to go from Lakehouse data to production models—without the spreadsheet chaos. You’ll get a practical blueprint for curated data layers, reproducible notebooks, MLflow tracking, governed model registry, and one-click batch/real-time serving. Includes a 14-day rollout plan, reliability/ROI metrics, and copy-paste snippets for Python + Fabric.
Listen to the Episode
Aug. 7, 2025

Using Copilot in Microsoft Fabric to Build Data Models

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 pipelines break, and then accelerates transformation with optimized steps, ready-to-use DAX, and auto-documentation. We cover performance tuning, debouncing bottlenecks, and Copilot’s visual guidance in Power BI that turns numbers into narratives people actually use. Finally, we show how feedback loops train Copilot—and sharpen your own modeling instincts—so every project gets faster and more accurate over time.
Listen to the Episode
Aug. 6, 2025

Implementing Row-Level Security in Power BI with Fabric

This episode shows why Row-Level Security (RLS) in Power BI isn’t a checkbox—it’s a living system. We unpack the parts that actually decide who sees what: model relationships, role design, DAX filters (static vs dynamic), Azure AD group assignments, and the identity shifts that happen when you publish to Fabric. You’ll learn safe DAX patterns (e.g., USERPRINCIPALNAME() with a User→Region bridge), how to avoid calculated-column traps, how to map and audit roles at scale, and how to test RLS where it matters (in the cloud, with real identities). Plus, we share a governance checklist for ongoing reviews so your data stays secure as teams and models change.
Listen to the Episode
Aug. 5, 2025

Monitoring Data Pipelines in Microsoft Fabric

This episode shows you how to stop flying blind in Microsoft Fabric by designing a proactive, system-level monitoring strategy. We break monitoring into four pillars—performance metrics, error logging, data lineage, and automated recovery—then wire them together so issues surface early, route to the right owners, and self-heal where possible. You’ll get concrete runbooks, alert patterns, dynamic thresholds, lineage-first impact analysis, and dashboard designs that scale—so your pipelines stay healthy, your SLAs hold, and your team finally gets ahead of failures.
Listen to the Episode
Aug. 5, 2025

Customizing Dataverse for Complex Business Apps

Tired of Dataverse apps that fly with 10 users and crumble at 100? This episode shows how to design for scale by treating relationships, logic, calculated fields, and alternate keys as first-class citizens—not afterthoughts. You’ll learn how to keep performance predictable, automation consistent, imports clean, and reporting trustworthy—so your model grows with the business instead of turning into spaghetti.
Listen to the Episode
Aug. 5, 2025

Building Ingest Pipelines in Microsoft Fabric for Enterprise Data

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, truncations, and schema-drift chaos into your lakehouse. You’ll see how Dataflows Gen2 catches and cleans bad rows before they land, how Pipelines excel at orchestration (not cleansing), and the exact playbooks to secure SQL, tame Azure Data Lake, and survive Dynamics 365 Finance throttling. Make one change now, save dozens of hours later—and stop getting paged when numbers don’t add up.
Listen to the Episode
Aug. 5, 2025

Unlock Dataverse—Stop Flying Blind in Fabric

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 that actually matter, and the shaping rules that turn GUID soup into revenue truth. We’ll show you how to model relationships, handle lookups, tame schema drift, and blend web + campaign + case data so you can track a click all the way to closed-won. Stop guessing at cause and effect—wire Dataverse into Fabric and watch your analytics light up.
Listen to the Episode
Aug. 4, 2025

Fabric Governance Is Not What You Expect

Think Fabric governance is “just like M365”? That’s the trap. This guide shows where your Microsoft 365 instincts help—and exactly where they fail—so you don’t mislabel datasets, over-permission workspaces, or miss audit events. You’ll learn how Fabric’s domains, workspace roles, and object-level overrides really work; why sensitivity labels and DLP don’t always propagate the way you expect; and how to stitch together audit + lineage for end-to-end investigations. Translate your M365 playbook, avoid the gotchas, and lock Fabric down without slowing the business.
Listen to the Episode
Aug. 4, 2025

Is Your Campaign Analytics Lying To You?

Stop waiting a week to learn your campaign flopped. Plug Dynamics 365 straight into Microsoft Fabric and watch email clicks, web journeys, and sales-stage changes stream into one live dashboard—updated in minutes, not Mondays. I’ll show you the exact signals to track (intent, not vanity), the real-time pipeline from D365 → Event Hub/Data Lake → Fabric → Power BI, and a lean dashboard design that turns streaming data into same-day budget pivots. Ditch stale reports and start optimizing while your audience is still listening.
Listen to the Episode
Aug. 4, 2025

Microsoft Fabric: M365’s Missing Link?

Tired of Power BI, Synapse, and Data Factory acting like strangers? Microsoft Fabric finally puts them under one roof—with OneLake as your single, governed source of truth. No more copy-paste datasets, brittle connectors, or audit scavenger hunts. In this guide, you’ll see how Fabric unifies storage, pipelines, analytics, and governance so M365 admins can cut wrangling time, tighten compliance, and ship trustworthy insights faster. If you manage data in Microsoft 365, this is the backbone you’ve been waiting for.
Listen to the Episode
Aug. 2, 2025

Hidden Dangers Inside Your Power BI Audit Logs

Your Power BI audit logs aren’t boring—they’re blowing the whistle. Hidden in that wall of “View Report” and “Share Dashboard” events are the clues behind your creeping license costs, ghost workspaces, risky external shares, and stale data decisions. Build one governance dashboard that fuses audit trails, tenant settings, workspace metadata, and license usage—and you’ll spot sprawl, waste, and risk weeks before finance or compliance does.
Listen to the Episode
July 31, 2025

You’re Missing Critical M365 Compliance Data – Here’s Why

Your Compliance Dashboard Is Lying to You: The Microsoft Graph Endpoints That Expose Hidden Risk (and How to Wire Them into Purview)If your M365 compliance reports always feel a step behind, you’re missing entire categories of incidents that never hit the default dashboards. In this episode, we show exactly which Microsoft Graph endpoints surface “invisible” risks—DLP hits, eDiscovery case activity, and security alerts—plus how to pull them with scripts (PowerShell/Python), fix auth and permissions, handle pagination, and centralize results in Microsoft Purview for audit-ready evidence. No guesswork—just the JSON that matters, turned into decisions.
Listen to the Episode
July 30, 2025

Microsoft Syntex Ends Data Silos—Here's How

Stop wasting hours hunting for the “final_final” contract. Microsoft Syntex turns your SharePoint and OneDrive chaos into searchable, compliant, metadata-rich content—automatically. In this episode, we show how Syntex classifiers and extractors tag the details that matter (vendor, totals, dates) so your files organize themselves, drive Power Automate workflows, and surface insight across Microsoft 365 and Purview. Ditch data silos, crush eDiscovery, and turn every document into living data—without becoming an AI expert.
Listen to the Episode
June 22, 2025

Microsoft Dataverse: The Trusted Data Backbone for Business Transformation

Your data isn’t the problem—your data plumbing is. Microsoft Dataverse turns scattered silos into a governed, secure backbone for apps, automations, and analytics across Power Platform and Dynamics 365. In this episode, we show how to model faster, ship apps sooner, lock down security, and light up insights—without duct-tape integrations.
Listen to the Episode
May 26, 2025

Why Power BI Copilot Requires a Broader Strategy

Power BI Copilot revolutionizes how you analyze data, enhancing productivity and accuracy. However, relying solely on this tool limits its potential. To unlock its full power, you need a broader approach. Strong data practices ensure high-quality inputs, while complementary tools expand its functionality. Training equips your team to use it effectively. By combining these elements, you transform Power BI Copilot into a cornerstone of your data strategy, driving better outcomes. Key Takeaways * F...
Listen to the Episode
May 20, 2025

Why Power BI Models Struggle to Deliver Results

Have you ever wondered why some Power BI Models seem to fall flat? It often happens because they lack a clear purpose or proper structure. Without a solid foundation, your data turns into a maze rather than a roadmap. When your model misses the mark, it’s harder to make sense of the numbers, let alone use them for smart decisions. The good news? Fixing this starts with understanding the basics of data modeling. Key Takeaways * Begin with a clear goal for your Power BI model . Decide what questio...
Listen to the Episode