Episodes

This episode shows how to unify Dynamics 365 HR, payroll, time/leave, and survey data in Microsoft Fabric to create a single, trustworthy HR analytics layer. You’ll see a practical lakehouse blueprint (Dataflows Gen2 → OneLake/Lakehouse → semantic model → Power BI) that eliminates spreadsheet reconciliation, standardizes IDs/fields, and refreshes metrics automatically. We cover core dashboards—headcount, onboarding SLAs, leave balances, DEI, and attrition—plus alerting and predictive insights (burnout/attrition risk) so HR can act early, not report late.

Exposing Dynamics 365 APIs through custom connectors in Power Platform enables secure, scalable integration between business applications, automation workflows, and external systems. But improper configuration can introduce security risks, performance issues, and governance gaps. In this guide, we explain how custom connectors work, how to securely expose Dynamics 365 APIs, and what architectural considerations matter in enterprise environments. You’ll learn about authentication strategies, permission management, environment isolation, and monitoring best practices. If you're building integrations between Dynamics 365 and Power Platform — this is the secure way to do it.

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.

This episode shows how to automate month-end close by wiring Power Automate + Dynamics 365 Finance + Microsoft Teams into a single approval and posting workflow. You’ll learn the exact connector, permissions, triggers, conditional approval logic, Teams adaptive cards, and resilient error-handling (timeouts, retries, escalations) that cut cycle time, keep auditors happy, and free finance from email ping-pong.

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.

Rolling forecasts miss the mark when D365 F&O actuals, sub-ledgers, and budgets live in silos. This episode shows how Microsoft Fabric unifies GL, AP/AR/FA and budget data into a single, governed model—so forecasts refresh with reality, variances reconcile themselves, and finance stops babysitting spreadsheets.

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.

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.

Stop babysitting Dynamics 365. In this walkthrough, you’ll wire up invoice approvals that run themselves, auto-route leads and cases to the right team, and stitch Sales, Finance, and Customer Service together with Power Automate and Copilot—no more swivel-chair updates, no more “did anyone follow up?” mysteries. You’ll get plug-and-play triggers, clean handoffs across modules, built-in audit trails, and a measurement plan that proves time saved. Turn D365 from a pile of one-off flows into a connected system that actually runs the business while your team focuses on the work that matters.

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.

Your Dynamics 365 dashboards don’t “just work” everywhere—and that mismatch is killing trust. This no-fluff breakdown shows why the same Power BI report behaves differently in Teams vs. SharePoint, how Dataverse fits (and where it doesn’t), and what to embed where for real-time decisions without license shock or stale data. Learn the exact setup that keeps field teams fast, execs confident, security tight, and costs sane—so dashboards get used, not bypassed.

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.

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.

Your role-based dashboard isn’t failing because of DAX—it’s failing because Azure AD, Power BI RLS, and Power Apps aren’t speaking the same identity language. This playbook shows how to wire dynamic AAD groups to dataset roles, pass user context from Power Apps into Power BI, and automate memberships so views personalize instantly (and safely) at scale. Stop shipping pretty demos that leak data or hide insights—build a zero-trust, persona-aware executive control center that actually holds up after go-live.

Your Teams isn’t a mess because people won’t follow rules—it’s a mess because creation is frictionless and governance starts too late. Fix the trigger and the sprawl dies: route every request through a templated, labeled, owner-verified Graph API flow; auto-expire and archive idle workspaces with smart nudges; then prove it works with Power BI lifecycle reporting. Build guardrails at birth, an invisible janitor in the background, and a feedback loop that keeps the place clean—without you living in scripts.

Stop tab-hopping and start resolving: We stress-tested Microsoft Teams inside Dynamics 365 to see if it actually saves SLAs—or just adds more clicks. Spoiler: when you hit “Collaborate,” chats stick to the ticket, context stays glued, and real-time swarms can shave minutes where it counts. But if your team spams chats or starts threads outside the record? Chaos creeps back in. Alerts in Teams rescue at-risk cases, outages have workarounds, and the payoff depends on discipline, not just the demo. Want fewer post-mortems and more first-time fixes? This is the playbook—warts and all.

Your phishing dashboard is lying to you. The “all good” charts hide near-miss clicks, silent investigations, and active campaigns threading your inboxes right now. We show how to tap Microsoft Defender’s buried signals and build living Power BI dashboards that expose what’s really happening—and what you’ll miss next unless you fix it.

Your “secure” files aren’t living on islands—they’re in a web of hidden links, group ripples, and quiet shares you’re not seeing. With Microsoft Graph Explorer, you can x-ray your tenant: hop from a user to every group, to every file, to every share, and finally to who actually touched the content. Map the shadow relationships across Teams, SharePoint, and OneDrive—and catch the surprises your admin portals gloss over.

Your audit logs aren’t protecting you—they’re politely lying. One careless share can walk your crown jewels out the door while “all good” dashboards nod along. We break down the exact policies, PowerShell patterns, and real-time alerts to expose every risky SharePoint/OneDrive link, trace who touched what, and lock it down at enterprise scale—without drowning in noise.

One “small” M365 hiccup can nuke your day—Teams spins, Outlook chokes, SharePoint vanishes—and your status page still says “healthy.” The culprit? Hidden dependencies (hello, Azure AD) that turn single glitches into cross-cloud pileups. Ditch the siloed runbooks. Build dependency-aware playbooks, off-platform comms, and decision trees that predict the dominoes before they fall.

Your SharePoint isn’t “slow”—your assets are. Flip the one switch pros use (Microsoft 365 Private CDN with tight origins) and watch pages snap to life. No fairy dust, just smarter delivery of images, CSS, and JS—plus a maintenance routine that keeps it fast when branding changes, sites sprawl, and content balloons.

Your SharePoint looks modern—but it’s secretly slowing your team down. Those pretty pages hide static lists, dead-end buttons, and buried actions that force people back to email and Excel. Flip the script: use SPFx (not just JSON) to make pages that do things—flag risks, trigger flows, push alerts to Teams, and surface live data without a single tab switch.

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.

Your SIEM isn’t blind—it’s blinking. Out-of-the-box connectors skip crucial M365 logs (mailbox forwarding, granular SharePoint sharing, Teams/Power Platform actions), so the “all good” green light is faking you out. Turn your SIEM from checkbox to chokehold: ingest the right audit streams, filter noise before it hits storage, normalize fields, and add detections that catch real attacker tradecraft.