M365.FM - Modern work, security, and productivity with Microsoft 365

IntroductionDid you know that every time you upload a document in SharePoint Online, at least four other Azure services get involved behind the scenes? The real action isn't just in your document library—the invisible cogs make or break performance. Curious what’s pulling the strings? Let's unpack how Azure AD, blob storage, content databases, and more coordinate in real time—and why understanding...

Most people use roughly 10 percent of what Microsoft OneNote can actually do — and then wonder why they are still drowning in a digital mess of random notes, buried meeting summaries, and ideas they can never find when they need them. OneNote is not just a digital notepad. When set up correctly, it becomes a connected, searchable, action-ready knowledge system that integrates directly with Microso...

Introduction to Microsoft DataverseMicrosoft Dataverse has emerged as the foundational data platform powering modern business applications, unifying disparate data silos and streamlining operations across industries. As organizations face increasing pressure to innovate—while reducing risk—Dataverse addresses the core issues of secure, scalable, and accessible data management for the Microsoft eco...

Introduction to Power Apps AI Builder: Modernizing the Way We WorkEvery organization wants to move faster, work smarter, and do more with less. Yet, the hurdle for most has always been bridging the gap between business users and advanced technology—especially when it comes to artificial intelligence (AI). Power Apps AI Builder solves exactly this challenge. With AI Builder, even those with little...

I use Microsoft Defender for Cloud because it gives me https://tei.forrester.com/go/Microsoft/DefenderForCloud/ . Every week, I see thousands of threats, from ransomware to phishing and cloud misconfigurations. Ransomware attacks now https://unit42.paloaltonetworks.com/2025-ransomware-extortion-trends/ , and https://www.secondstartechnologies.com/blog/2024/01/the-evolution-of-cybersecurity-staying...

Power BI Copilot is a powerful AI tool — but most teams only scratch the surface of what it can do. The real bottleneck isn't the technology. It's the lack of a comprehensive data strategy built around it. Without strong governance, seamless integration, and skilled users, even the best AI copilot will underdeliver. This episode breaks down exactly why Power BI Copilot requires a broader strategy...

Most organizations are sitting on untapped innovation potential — and it lives in the people who know their business processes best. Citizen developers, empowered with the Microsoft Power Platform, are turning business knowledge into working apps, automated workflows, and real-time data insights without writing a single line of code. This episode explores why empowering citizen developers with Pow...

Most Power BI models don’t fail because of bad data — they fail because of bad design. Poor planning, unclear business objectives, over-complicated schemas, and a lack of data modeling expertise are the four root causes behind underperforming Power BI projects. If your reports are slow, your stakeholders are confused, or your dashboards aren’t driving decisions, this episode explains exactly why —...

Cyber threats are evolving faster than most security teams can respond — and AI is now on both sides of that battle. Microsoft Copilot for Security brings AI-powered threat detection, real-time incident response, and data protection directly into your Microsoft 365 environment. This episode explores how Microsoft Copilot actively protects your organization’s sensitive data from phishing, ransomwar...

Without a clear governance framework, Microsoft Teams quickly becomes a chaos of uncontrolled channels, unmanaged data, and frustrated users. Teams governance is the strategic foundation that separates organizations that scale collaboration from those that struggle with sprawl, compliance gaps, and failed adoption. This episode explores how effective Teams governance drives real collaboration, bus...

Confession time: the first time I opened a model-driven form in Power Apps, I had no idea what I was looking at. It felt like peeking under the hood of a spaceship—exciting, but intimidating. What began as a practical experiment soon spiraled into a deep, surprisingly personal quest for order (and maybe a little bit of software zen). Ever felt a tool teach you something about your own need for str...

(00:00:00) Effective instructions for agents (00:10:15) Harnessing knowledge sources (00:23:27) Empowering actions in AI (00:35:49) Choosing the right integration (00:52:40) Enhancing AI with generative orchestration (01:00:55) Best practices for testing Imagine a tool so powerful it doesn’t just help you work—it actually transforms how you work. Picture this: you describe what you want, and it ma...

Ever spent what feels like an entire weekend transforming a “simple” CSV file into something usable? In this episode, I walk through how Microsoft Copilot in Fabric turned those soul‑crushing hours of ETL, Spark debugging, and fiscal calendar building into tasks that now take minutes instead of days. You’ll hear the real story behind that shift—from skepticism and fear of being replaced to the mom...

(00:00:00) Connecting Microsoft 365 services (00:10:33) Unlocking insights with Teams data (00:22:57) Visualizing SharePoint collaboration metrics (00:35:47) Ensuring Graph API security (00:47:02) Integrating data for better insights (01:02:19) Proactive reporting with Graph API (01:12:55) Mastering Graph API for growth Let me start with a confession: Not so long ago, I considered Microsoft 365 an...

You can tell an update really matters when it’s suddenly 2 a.m., your coffee is cold, and you’re five tabs deep into docs, demos, and Git branches. That was me during Microsoft Fabric’s March 2025 release, chasing every new feature and realizing this isn’t “just another incremental patch” but a step change toward Fabric being the backbone of enterprise data strategy instead of a loose collection o...

Every Power Platform story starts with good intentions: someone wants to automate a boring task, build a small app, or finally get a dashboard that makes sense. But the moment you add real company data, you’re no longer just “building solutions”—you’re creating new ways things can go wrong. In this episode, I team up with Marcel to explore what happens when low‑code innovation, self‑service, and r...

If you’ve ever given someone “temporary” admin rights and then forgotten to take them back, you already know how Microsoft Entra roles can quietly turn into your biggest security risk. In this episode, we turn SC‑900 Entra roles theory into real‑world stories—from over‑permissioned junior admins to “just for now” shortcuts that become permanent attack paths—so you finally see how least privilege w...

When you first move from classic on‑prem Active Directory into Microsoft Entra ID, it can feel like learning a new language while still keeping the old system running. In this episode, we turn that confusion into a structured SC‑900 learning path: from on‑premises AD to hybrid setups to full cloud identity, so you understand what actually changes in daily operations—not just in Microsoft’s documen...

Microsoft security fundamentals are no longer “nice to have” theory for exam prep—they decide whether your organization survives the next breach. In this episode, we turn the SC‑900 exam objectives into real‑world scenarios from cloud, hybrid, and remote‑work environments, so you learn how confidentiality, integrity, and availability show up in your daily tools instead of just on a certification s...

(00:00:00) Understanding row-level security (00:15:53) Exploring object-level security (00:30:12) Benefits of incremental refresh (00:38:19) Optimizing Power BI performance (00:57:41) Enhancing analysis with visuals (01:05:06) Ensuring data quality (01:15:44) Unlocking insights with T-SQL Most teams “turn on” incremental refresh and hope for the best—then wonder why refresh windows creep into busi...

(00:00:00) Diagnosing performance issues (00:09:26) Optimizing SQL queries (00:23:13) Effective data partitioning (00:34:08) Delta table optimization techniques (00:44:08) Maintaining delta table efficiency (00:53:13) Balancing data models (01:06:17) Sustaining performance gains (01:15:47) Integrating monitoring practices Microsoft Fabric promises seamless data analytics, but the path to mastering...

(00:00:00) Introduction to data flows (00:07:14) Understanding data pipelines (00:23:20) Real-time data shortcuts (00:31:39) Integrating tools for efficiency (00:41:40) Managing dependencies with lineage (00:49:15) Role of stored procedures (00:58:37) Optimizing data transformations (01:05:43) End-to-end automation overview In this episode of M365.fm, Mirko Peters takes you from ingestion anxiety...

(00:00:00) Foundations of data planning (00:14:21) Mastering capacity planning (00:24:38) Choosing data gateways wisely (00:39:06) Admin portal essentials (00:46:46) Designing effective Power BI themes (00:54:02) Hands-on fabric experience (01:10:15) Avoiding common planning mistakes Microsoft Fabric DP‑600 is not just about learning features; it is about learning to plan like an analytics enginee...

“We’ve been hacked.” In this episode of M365.fm, Mirko Peters takes you from that sick feeling in your stomach to a structured view of modern cybersecurity, using his own first breach scare and the SC‑900 certification as a lens for what actually matters today. He starts in the war room: nervous meetings, incomplete logs, and the realization that one weak password, one missing control, or one unpr...

In this episode of M365.fm, Mirko Peters takes you behind the scenes of the Copilot Studio Challenge—showing how you can build working AI assistants in just 24 hours without writing a single line of code. Starting from a blank Copilot Studio tenant and a ticking clock, he walks through the mindset, planning, and practical steps that turned a vague idea into a fully functioning helper that answers...