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

Episodes

Sept. 28, 2025

Why Azure AI Foundry Projects Fail: Common Pitfalls & How to Fix Them

In this episode we walk through what really happens when Azure AI Foundry doesn’t behave the way you expect, especially when the Agent Service or deployments start acting up. Azure AI Foundry is supposed to feel smooth, almost invisible, tying together OpenAI models, search, storage, and all the moving parts behind an AI application. But sometimes things slip, the agent stops talking to its resources, deployments stall, endpoints go quiet, and suddenly you’re trying to figure out what broke where. Most of the time the story starts with the Agent Service, the piece that quietly moves requests around, calls other Azure services, handles identities, and keeps the internal wiring alive. When it stumbles you see failed API calls, permissions errors, or models that never fully deploy. You open the portal, you dig through the logs, you check whether the managed identity has access to Cosmos DB, Storage, or Search, and you make sure nothing in the network layer or a recent security update cut…
Guest: Mirko Peters
Why Azure AI Foundry Projects Fail: Common Pitfalls & How to Fix Them
M365 FM Podcast
Why Azure AI Foundry Projects Fail: Common Pitfalls & How to Fix Them
Sept. 27, 2025

Autonomous Agents: Productivity Hack or Admin Nightmare?

The real shift is autonomous AI agents – systems that don’t just answer a prompt and wait for the next human nudge, but notice, decide, and act on their own. Not a “bot that replies in Teams,” but a worker that reads the situation, picks a plan, executes it, and learns from whatever broke along the way.An autonomous AI agent is basically an AI-powered loop: sense, think, act, learn. It pulls in signals from APIs, logs, documents, sensors, whatever you feed it. It builds an internal picture of “what’s going on,” runs that through models and planning logic, picks an action, executes it, and then uses the outcome as feedback to adjust its strategy. No one is there hand-holding it through each click. You set goals and constraints; it figures out the steps.They come in flavors. Some are laser-focused goal agents: “keep this metric green,” “close as many tickets as possible,” “optimize this schedule.” Some are reflexive: “if this happens, do that, instantly.” Others are true learnin…
Guest: Mirko Peters
Autonomous Agents: Productivity Hack or Admin Nightmare?
M365 FM Podcast
Autonomous Agents: Productivity Hack or Admin Nightmare?
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
Power BI Version Control & Collaboration: GitHub, CI/CD & Best Practices
M365 FM Podcast
Power BI Version Control & Collaboration: GitHub, CI/CD & Best Practices
Sept. 26, 2025

Stop Wasting Time in M365: How Microsoft Syntex Automates Your Documents

This episode argues that Syntex being folded into SharePoint Premium is not a naming joke — it’s Microsoft consolidating content processing, content experiences and governance into one platform so Copilot can stop guessing and start delivering real answers.SharePoint Premium =Brain (content experiences) + Muscle (content processing) + Bouncer (governance)When those three are unified → content becomes structured + governed + queryable → and that is what finally makes Copilot useful.Real-world proof: orgs like London Stock Exchange cut document processing time from hours → minutes.The real danger isn’t bad AI — it’s good AI running without guardrails and multiplying bad classification + oversharing mistakes.Governance is not optional. It’s the safety net.Key tactic: start with 1 high-value process (invoices/contracts), use prebuilt models first, measure time saved, then scale.
Guest: Mirko Peters
Stop Wasting Time in M365: How Microsoft Syntex Automates Your Documents
M365 FM Podcast
Stop Wasting Time in M365: How Microsoft Syntex Automates Your Documents
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
Power BI Star Schema: The Pro Trick No One Teaches (Data Modeling Secrets)
M365 FM Podcast
Power BI Star Schema: The Pro Trick No One Teaches (Data Modeling Secrets)
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
Power BI Alerts vs Fabric Data Activator: Key Differences Explained
M365 FM Podcast
Power BI Alerts vs Fabric Data Activator: Key Differences Explained
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
Power BI Deployment: How to Do It Like a Pro (No More Guesswork)
M365 FM Podcast
Power BI Deployment: How to Do It Like a Pro (No More Guesswork)
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
T-SQL vs SQL: How T-SQL Eliminates IT Bottlenecks
M365 FM Podcast
T-SQL vs SQL: How T-SQL Eliminates IT Bottlenecks
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
How Power BI Turns SharePoint Chaos Into Clarity
M365 FM Podcast
How Power BI Turns SharePoint Chaos Into Clarity
Sept. 23, 2025

Model-Driven Apps: The Unsung Power Platform Hero

This episode breaks down model-driven apps in Power Apps and shows you exactly how to master them using Microsoft Learn. If you’ve ever wondered when to use a model-driven app, how Dataverse fits into the picture, or why business logic matters so much, this is your crash course. We walk through the core components—tables, views, forms, dashboards, custom pages—and explain how a solid data model becomes the backbone of an enterprise-grade app.You’ll learn how Dataverse powers secure, structured data management, why business rules and process flows save you from bad data, and how to customize tables so your app mirrors real business processes—not the other way around. We also cover publishing, sharing, and securing your app, including how to use security roles to control access and drive adoption.Then we map out the best Microsoft Learn modules and learning paths so you know exactly where to start, how to level up, and how to connect the dots between Dataverse, Power Automate, a…
Guest: Mirko Peters
Model-Driven Apps: The Unsung Power Platform Hero
M365 FM Podcast
Model-Driven Apps: The Unsung Power Platform Hero
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
Dataverse Migration: Why Every Power Platform Eventually Hits This Wall
M365 FM Podcast
Dataverse Migration: Why Every Power Platform Eventually Hits This Wall
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
Why Copilot Fails: The Data Quality Problem Nobody Talks About
M365 FM Podcast
Why Copilot Fails: The Data Quality Problem Nobody Talks About
Sept. 22, 2025

GitHub vs Azure DevOps vs Fabric: Who Actually Owns Your Deployments?

Microsoft Fabric Git Integration is changing the game for anyone building modern data platforms, and in this episode we break down exactly how it works and why it matters. Discover how Microsoft Fabric seamlessly connects to Azure DevOps and GitHub, giving you full version control, automated deployments, and a true end-to-end CI/CD workflow for everything from semantic models to Power BI reports. This episode shows how Fabric unifies your data engineering, data warehousing, and analytics tools while Git integration brings collaboration, code tracking, and environment consistency to the entire process. We also explore how Azure DevOps Pipelines and GitHub Actions can automatically build, test, and deploy your Fabric content, helping teams ship updates faster, avoid errors, and maintain total governance across dev, test, and production environments. If you're ready to level up your data operations, streamline deployments, and unlock the full power of Microsoft Fabric with Git, Azure Dev…
Guest: Mirko Peters
GitHub vs Azure DevOps vs Fabric: Who Actually Owns Your Deployments?
M365 FM Podcast
GitHub vs Azure DevOps vs Fabric: Who Actually Owns Your Deployments?
Sept. 21, 2025

Power Automate Approval Workflow: Why You Can’t Trust the Audit Trail

Automating approval workflows has become essential for organizations that want to move faster, eliminate manual bottlenecks, and keep their processes compliant. In this episode, we break down how Microsoft Power Automate and SharePoint work together to create powerful, reliable approval workflows that handle requests instantly and keep every step fully tracked. You’ll learn how approval automation works, why it matters, and how to build an approval flow that triggers the moment a SharePoint item is created, sends a structured approval request to the right people, waits for a response, and updates your data automatically. We explore how to configure approvers, customize approval logic, manage approval status in SharePoint, and use advanced features like sequential and parallel approvals. By the end, you’ll understand how Power Automate and SharePoint can streamline your entire approval process, reduce errors, improve visibility, and deliver a smooth, modern approval experience that tra…
Guest: Mirko Peters
Power Automate Approval Workflow: Why You Can’t Trust the Audit Trail
M365 FM Podcast
Power Automate Approval Workflow: Why You Can’t Trust the Audit Trail
Sept. 21, 2025

Is Microsoft Copilot worth it? Many organizations don’t see enough ROI—and the data explains why.

Microsoft 365 Copilot AI is making waves across the tech world, but the real question is whether it’s a revolutionary leap forward or just the latest overhyped gimmick. In this episode, we unpack what Copilot actually is, how deeply it integrates with the Microsoft 365 ecosystem, and whether its AI-powered features truly move the needle for everyday productivity. Copilot promises to transform the way users work in Word, Excel, PowerPoint, Outlook, and Teams by generating content, summarizing information, answering questions, analyzing data, and automating tasks. We explore how generative AI and large language models make this possible, how Copilot adapts to different workflows, and what its growing customization options mean for users who want more control. At the same time, we dig into the ongoing debate: is Copilot a meaningful AI assistant or just another shiny feature destined to fade like past Microsoft experiments? With predictions pointing toward full integration and even more …
Guest: Mirko Peters
Is Microsoft Copilot worth it? Many organizations don’t see enough ROI—and the data explains why.
M365 FM Podcast
Is Microsoft Copilot worth it? Many organizations don’t see enough ROI—and the data explains why.
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
I Thought My Power BI Gateway Was Fine… Until Everything Broke
M365 FM Podcast
I Thought My Power BI Gateway Was Fine… Until Everything Broke
Sept. 20, 2025

Teams Channels vs Chat: You’re Probably Using Them Wrong

Microsoft Teams channels are one of the most powerful yet misunderstood features in the entire Teams platform, and using them correctly can make or break your organization’s communication. In this episode, we dive into how Teams channels actually work, why they matter, and how to structure and manage them so your team stays organized instead of drowning in clutter. We break down the difference between standard, private, and shared channels, how naming and descriptions impact collaboration, and why organizing files inside each channel is essential for keeping projects on track. You’ll learn how to communicate effectively in channel conversations, when to use chat versus a channel post, how to avoid common mistakes like broken threads or lost messages, and what admins should know about permissions, access issues, deleted channels, and external collaboration. We also explore the connection between Teams and SharePoint, showing how every channel uses SharePoint behind the scenes and how u…
Guest: Mirko Peters
Teams Channels vs Chat: You’re Probably Using Them Wrong
M365 FM Podcast
Teams Channels vs Chat: You’re Probably Using Them Wrong
Sept. 20, 2025

SharePoint Framework Live Updates Broken? Fix Your SPFx Data Flow

Real-time data is becoming essential in modern workplaces, and SharePoint is no exception. In this episode, we explore how developers can unlock powerful real-time experiences in SharePoint Online using SPFx web parts connected to dynamic APIs. You’ll learn how SharePoint and the SharePoint Framework work together, how SPFx taps into Microsoft Graph and the SharePoint REST API, and how to build custom web parts that pull live data directly into SharePoint pages. We break down what real-time data actually means, why it matters, and how it transforms dashboards, project sites, and intranet pages into constantly updating, actionable information hubs. You’ll also discover what goes into creating an SPFx web part from the development environment setup to integrating APIs, handling authentication, designing responsive UI, solving performance bottlenecks, and securing data connections. If you want to build modern, dynamic, constantly updated SharePoint solutions that truly keep your users in…
Guest: Mirko Peters
SharePoint Framework Live Updates Broken? Fix Your SPFx Data Flow
M365 FM Podcast
SharePoint Framework Live Updates Broken? Fix Your SPFx Data Flow
Sept. 19, 2025

Microsoft Purview Data Governance: The Info Architect’s Survival Guide

Microsoft Purview has quickly become one of the most important tools for modern data governance, and in this episode we break down exactly how its architecture works, why organizations rely on it, and how to put best practices in place to protect sensitive information across Microsoft 365, Azure, multi-cloud, and on-prem environments. You’ll learn how the Purview Data Map discovers, classifies, and catalogs data, how the governance portal ties everything together, and why strong information architecture is the foundation for successful data governance. We explore how Purview integrates with Microsoft 365, SharePoint, Teams, and Defender to deliver end-to-end visibility, risk reduction, and compliance, and how features like data classification, retention labels, access controls, and DLP policies help organizations secure their data without slowing down productivity. This episode also covers deployment steps, security considerations, and strategies for building a scalable, future-ready …
Guest: Mirko Peters
Microsoft Purview Data Governance: The Info Architect’s Survival Guide
M365 FM Podcast
Microsoft Purview Data Governance: The Info Architect’s Survival Guide
Sept. 19, 2025

Microsoft Teams Adaptive Cards: Fix Useless Notifications with Actionable Workflows

Managing notifications in Microsoft Teams can be the difference between staying focused and feeling overwhelmed, and in this episode we break down exactly how to take control of them. You’ll learn how Teams notifications actually work, how to customize alerts for chats, channels, meetings, and activity, and how to fine-tune the balance between staying informed and avoiding nonstop interruptions. We walk through the difference between banner alerts, activity feed updates, sound notifications, and mobile push notifications, and explain how to tailor each one so you only receive what truly matters. You’ll also discover how to manage notifications on desktop and mobile, mute noisy channels, adjust default settings, fix notification issues, and troubleshoot common problems like missing alerts or delayed messages. If Microsoft Teams feels chaotic or distracting, this episode shows you how to configure it so notifications work for you—not against you—and help you stay productive without miss…
Guest: Mirko Peters
Microsoft Teams Adaptive Cards: Fix Useless Notifications with Actionable Workflows
M365 FM Podcast
Microsoft Teams Adaptive Cards: Fix Useless Notifications with Actionable Workflows
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
Microsoft Fabric Domains: Why They Don’t Fix Your Governance Problem
M365 FM Podcast
Microsoft Fabric Domains: Why They Don’t Fix Your Governance Problem
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
LINQ to SQL: Magic or Mayhem?
M365 FM Podcast
LINQ to SQL: Magic or Mayhem?
Sept. 17, 2025

Dirty Code vs Clean Code: Why Messy Code Wins (Until It Doesn’t)

Writing readable code is one of the most underrated skills in software development, and in this episode we break down exactly why it matters and how developers can master it. You’ll learn what truly makes code readable, how clean-code principles like the Single Responsibility Principle shape maintainable systems, and why consistent formatting and naming conventions can transform even the messiest codebase into something elegant and easy to navigate. We explore how to identify code smells, when and how to refactor, and why continuous cleanup prevents technical debt from silently growing out of control. You’ll also discover how thoughtful commenting, small focused functions, and team-wide coding conventions help every developer write code that is easy to understand, easy to debug, and easy to extend. If you want to level up your craft, write clearer logic, collaborate more effectively, and build software that stands the test of time, this episode gives you the complete roadmap to writin…
Guest: Mirko Peters
Dirty Code vs Clean Code: Why Messy Code Wins (Until It Doesn’t)
M365 FM Podcast
Dirty Code vs Clean Code: Why Messy Code Wins (Until It Doesn’t)
Sept. 17, 2025

No-Code vs. Pro-Code: Security Showdown

Choosing between low-code, no-code, and pro-code can feel overwhelming, and in this episode we break down exactly what each approach means, how they differ, and when each one is the right fit. You’ll learn how pro-code gives developers full control and unlimited customization, why low-code strikes a powerful balance between speed and flexibility, and how no-code enables business users to build apps without writing a single line of code. We explore real-world use cases, the strengths and limitations of each method, and how organizations are blending these approaches to accelerate development while maintaining quality and scalability. Whether you're trying to empower citizen developers, speed up delivery, or build complex enterprise systems, this episode gives you the clarity you need to choose the right development strategy for your team and your goals.
Guest: Mirko Peters
No-Code vs. Pro-Code: Security Showdown
M365 FM Podcast
No-Code vs. Pro-Code: Security Showdown