Power Platform Episodes

This episode explains the real difference between automation and agents, cutting through the confusion created by marketing and buzzwords. Automation is framed as rigid and repetitive, useful for consistent, rule-based tasks but incapable of adapting when conditions change. Agents, by contrast, are autonomous systems that observe their environment, plan their next steps, and act based on judgment rather than fixed scripts. That difference matters because agents can carry memory, adapt to new situations, and make decisions without constant human intervention, while automation simply replays instructions. The core of true agent behavior is the Observe–Plan–Act loop. Agents continuously gather signals from their environment, reason about possible actions using memory and goals, execute decisions through integrations, and then learn from the results. This loop allows agents to improve over time instead of breaking when something unexpected happens. Without this cycle, a system may look…

Your SharePoint isn’t “old” — your legacy workflows are. The episode shows how to modernize without rebuilding: keep your lists/libraries, then layer Power Apps for usable front-ends, Power Automate for reliable approvals, AI Builder to auto-classify/extract from PDFs, and Copilot Studio for conversational retrieval and actions. It stresses urgency: SharePoint 2010 workflows are retired; 2013 workflows are disabled for new tenants (Apr 2, 2024) and fully retire in SharePoint Online on Apr 2, 2026. Quick audits + replacements turn a “2013 dungeon” into an AI-powered hub—with governance intact (AI Builder training data stored in Dataverse, visible only to the model owner or approved admins).

SharePoint Premium with SharePoint Advanced Management (SAM) is the governance backbone that keeps Copilot from turning oversharing into a data leak. You’ll learn how to spot risky sites with Data Access Governance (DAG), lock down visibility with Restricted Access Control (RAC), use Site Access Reviews to make owners accountable, and apply AI Insights to prioritize fixes. Think moat + walls + watchtowers: RBAC is the moat; SAM builds the walls; DAG/AI Insights are the watchtowers; owners are the guards.

Your first Copilot Studio agent shouldn’t guess policy—it should cite it. This episode shows how to recreate a bad reply in the Test pane, ground answers in real docs, shape a trustworthy persona, and publish a pilot that survives Teams/SharePoint quirks. Treat Studio as sparring, not proof; ground, persona-tune, and channel-test before you scale.

If you can paste the exact title of a file into intranet search and still get nothing back, you don’t have a user problem—you have an Information Architecture (IA) problem. This episode shows how to fix the foundations so both humans and Copilot can actually find things. We break IA into six core elements—global navigation, hub navigation, local navigation, metadata, search, and personalization—and explain how each one supports the others. You’ll see why “Studio-perfect” AI is useless if your sites are a maze, why flat site architecture + hubs beat old nested subsites, and how mandatory, lightweight metadata (content types, owner, status, region) turns search from guesswork into precision. We’ll map the three navigation layers (world, region, street), show quick tests to spot bloat and dead ends, and explain how audience targeting + Viva Connections deliver the right content to the right roles without manual tinkering. Bottom line: fix the map, tag the loot, and target the drop—then C…

Rolling out Microsoft 365 Copilot is only the tutorial, not the boss fight. Your first agent may look perfect in Copilot Studio, but production exposes the real challenges: grounding answers in authoritative sources, governance to prevent sprawl, monitoring for reliability, and licensing/cost controls so the meter doesn’t explode mid-month. Think in layers: the foundation model, orchestrator, grounding, and skills/connectors must operate as one stack—or you’ll scale confident nonsense. Choose the right build path: Copilot Studio for low-code speed and admin guardrails; Teams/Agents Toolkit for full-stack control, custom orchestration, and deep integrations. Then feed the brain: connect SharePoint, Dataverse, Graph data, and external systems (securely) so responses come with citations, not guesses. Lock down Purview labels, DLP, diagnostics logs, and least-privilege roles before broad release, and watch the copilot consumption meter (or PAYG) so testing doesn’t drain production. Succes…

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 differ from calculated columns. You'll learn when and why replacing a measure makes sense—whether for performance gains, model cleanup, or updating outdated logic. We walk through the step-by-step process of replacing measures in Power BI Desktop, including analyzing existing DAX, deciding between a new calculated column or a revised measure, and updating visuals to ensure accurate results. We also cover common troubleshooting issues like broken visuals, context-related errors, and performance bottlenecks—and how to avoid them. The episode also explores DAX fundamentals, including essential functions like CALCULATE, VAR, SUM, and SWITCH, along with best practices for writing clean, efficie…

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 clear explanation of how each plan works and what it offers. We discuss how Power BI pricing supports everyone—from individual users exploring Power BI Desktop to large enterprises relying on dedicated capacity and advanced analytics. You’ll hear how each licensing model fits different business needs, what Power BI Pro includes for collaboration and report sharing, and when it makes sense to invest in Premium for scalability, AI-powered features, and improved performance. We also explore Power BI Embedded for app developers and explain how consumption-based pricing factors into capacity planning. The episode covers the key factors to consider when choosing a Power BI plan, including user …

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 reports, and make data-driven decisions without switching apps. You’ll learn the basics of Power BI—connecting to data, creating reports, and publishing dashboards—alongside an overview of Microsoft Teams as a unified workspace for communication and collaboration. We explain how embedding Power BI reports into Teams channels enhances visibility, streamlines discussions, and keeps everyone aligned around the same analytics. The episode walks through practical steps for embedding, sharing, and accessing Power BI content in Teams using the Power BI app. We highlight how teams can collaborate in real time, discuss insights directly next to visualizations, and make reporting part of everyday wor…

In this episode, we walk through how to integrate with Microsoft Dynamics 365 using its powerful API capabilities, focusing on the REST-based Web API that provides secure and flexible access to CRM data. We start with an introduction to Dynamics 365 as a suite of intelligent business applications and explain how its CRM features—sales, marketing, and customer service—become even more powerful when connected through APIs. You’ll learn about the different API options in Dynamics 365, including the Web API and Organization Service, and why REST APIs are the go-to choice for modern integrations. We cover the essentials of getting started: setting up your Dynamics environment, configuring permissions, authenticating with OAuth 2.0, and making your first API call using standard HTTP methods. The episode also breaks down how to perform key data operations—creating, retrieving, updating, and deleting CRM records—using the Dynamics 365 Web API. We discuss how to handle JSON responses, ma…

In this episode, we break down Power Pages—Microsoft’s low-code tool for building secure, data-driven websites—and explain how its licensing, capacity limits, and alternative solutions compare. You’ll learn what Power Pages is, how it integrates with Dataverse and the Power Platform, and why organizations use it to quickly create customer portals, partner sites, and self-service web experiences without heavy custom development. We cover the key features of Power Pages, including its low-code design studio, support for authenticated and anonymous users, and native integrations with Power Apps, Power Automate, Power BI, and Dynamics 365. You’ll hear how these capabilities help teams build interactive sites that connect directly to business data and automate workflows across the Microsoft ecosystem. A major focus of the episode is the Power Pages licensing model—how authenticated and anonymous user licenses work, how page views affect pricing, and how Power Apps or Dynamics 365 lic…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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.

Mapping SharePoint or SharePoint Online as a network drive sounds convenient, but in this episode we break down what it really means, why organizations consider it, and when it actually makes sense. You’ll learn how SharePoint document libraries work behind the scenes, how mapped drives behave in Windows, and why many users run into slow performance, sync problems, and missing features when treating SharePoint like a traditional file share. We explore the pros and cons of direct drive mapping, why OneDrive sync is the method Microsoft recommends, and how each option affects metadata, version history, permissions, and everyday collaboration. You’ll also discover practical alternatives, best practices for accessing document libraries, and how site maps, web parts, and modern navigation help users find and manage content without relying on outdated mapped-drive techniques. If you’ve ever wondered whether mapping SharePoint as a network drive is a smart strategy or a headache waiting to h…

This episode uncovers the real scalability limits of the Power Platform and shows how to avoid the performance issues that often catch teams off guard. Through candid stories and expert insights, it explains where apps typically hit bottlenecks, what early warning signs to watch for, and which design decisions can quietly create major slowdowns or unexpected costs. Listeners get case studies of apps that failed under load — along with the specific mistakes behind them — plus practical strategies like partitioning, batching, and offloading heavy workloads. The episode also breaks down how scale affects licensing, when to move functionality to SaaS or custom services, and how to monitor the metrics that truly matter before users experience issues. It closes with guidance on future-proofing architecture and extending scalability without having to rebuild everything later. The goal is to equip architects, makers, and developers with the knowledge and tactics needed to design Power P…