Episodes

Dynamics 365 deployments fail less because of code and more because of packaging gaps: hidden dependencies, unmanaged/managed mix-ups, missing environment variables and connection references, and un-migrated configuration data. In this episode, we show how to ship reliably by mapping dependencies up front, using managed solutions for prod, aligning layers in a sandbox, and treating env config + reference data as first-class deployment artifacts. You’ll get an end-to-end release blueprint—import, configure, migrate, validate—plus tooling tips (Solution Checker, dependency analysis, config migration) to prevent “works in dev, breaks in prod” disasters.

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.

Tired of manual, brittle Power Platform deployments? This guide shows how to build a reliable CI/CD pipeline with Azure DevOps that handles the real trouble spots: environment variables, connection references, service connections, and secure secrets. Learn exactly what a solution package includes (and what it doesn’t), how to parameterize per-environment settings, bind connections after import, and protect credentials with Key Vault. You’ll get a reusable YAML blueprint (build → store artifact → import → set env vars → map connections → smoke test → notify), plus rollback, monitoring, and governance practices so releases are fast, auditable, and drama-free.

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.

Most Microsoft 365 automations fail for the same reason: they rely on fragile delegated permissions tied to human users—leading to session timeouts, MFA prompts, role changes, and broken jobs. The fix is shifting to app-only permissions with Microsoft Graph: run headless, least-privilege, auditable automations via a service principal (no user login, no expiring sessions). This guide shows why delegated breaks at scale, how to set up app-only securely (registration, Application permissions, admin consent, Key Vault secrets), and how to extend it with Graph webhooks for real-time, reliable workflows across SharePoint, Teams, and Outlook—without babysitting logins.

Power Platform chaos across dev/test/prod isn’t inevitable. The Power Platform CLI (PAC CLI) turns fragile, click-heavy moves into repeatable DevOps: scripted solution packaging, versioning, dependency checks, and plug-in registration you can trust. Use PAC CLI to isolate auth per tenant, pack managed solutions with all references, automate plug-in deployments, and wire releases into Azure DevOps/GitHub Actions. Result: predictable migrations, fewer “works in dev” surprises, clean rollbacks, and real traceability—without abandoning the maker portal for day-to-day tweaks.

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.

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.

Turn Dynamics 365 lead scoring into a revenue engine. This guide shows how D365’s AI turns behaviors (opens, replies, page views, meetings), firmographics, and sales outcomes into predictive scores—then converts those scores into next-best actions. You’ll get a clean, step-by-step rollout plan, data hygiene checklist, automation recipes, and metrics (lift, precision@k) to prove impact fast.

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.

Copilot in Dynamics 365 Sales is a quiet force multiplier, not a miracle. It reliably saves minutes on drafting emails, nudging follow-ups, and surfacing status—especially in standard motions. It stumbles when CRM data is stale, workflows are bespoke, or you expect it to replace nuance. Treat outputs as first drafts and pair AI ranking with human judgment to avoid chasing noisy leads. Pilot with clean data, tight guardrails, and clear success metrics—then scale.

This episode explains why one-off “thank you” emails from Dynamics 365 (D365) fall flat—and how to replace them with adaptive customer journeys that boost replies, retention, and revenue. You’ll learn how to use D365 signals and Power Automate to trigger timely check-ins, tailored product tips, and honest feedback requests based on real customer actions. We cover which D365 events matter (beyond “case created” and “opportunity won”), how to segment by status changes, purchase frequency, and satisfaction trends, and how to build guardrails like suppression windows and frequency caps. We also show how to close the loop by routing low CSAT to human follow-ups, turning high CSAT into reviews and referrals, and feeding engagement data into continuous improvement via A/B tests and Power BI. If you want emails that start conversations—not end them—this practical walkthrough will help you design dynamic, data-driven flows that keep customers engaged and coming back.

This episode shows how to turn Dynamics 365 Marketing from a linear “set-and-forget” email engine into a responsive system that reacts to real user behavior. You’ll learn how to capture high-signal actions—like pricing-page visits, form starts and abandons, and in-app feature usage—and convert them into adaptive journeys using triggers, conditions, and branches. We cover wiring journeys to prevent duplicate messages, adding multi-channel touches (email, SMS, in-app), and using journey analytics to spot drop-offs, fix LinkedIn integration overlaps, and prove ROI. If your D365 campaigns start strong then fizzle, this step-by-step playbook helps you architect smarter paths that send the right message, at the right time, to the right contact.

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.

This episode shows how to supercharge targeting in Dynamics 365 Customer Insights by moving beyond demographics to behavior- and transaction-driven segmentation. You’ll learn how to unify web, CRM, commerce, and support data; build dynamic segments using calculated measures and intent signals; and activate those segments across D365 Marketing, Sales, and Power Automate for real-time campaigns. We cover data onboarding, matching/merge rules, engagement scoring, churn and upsell indicators, and guardrails to avoid stale or duplicate outreach—so high-value leads surface faster and conversion rates climb.

This episode exposes the hidden gaps in Fabric and Power Platform Data Loss Prevention (DLP)—from shadow connectors and cross-environment leaks to misclassified “business” connectors that quietly exfiltrate sensitive data. You’ll learn how DLP decisions are really made (the if-then logic behind policies), how to map actual data flows across apps, environments, and connectors, and how to classify risk without choking productivity. We share an adaptive testing playbook—pilot scopes, sandbox simulations, analytics-driven tuning, and guardrails—so you can block personal Dropbox/OneDrive/Gmail escapes, stop custom connector surprises, and keep critical workflows running. If you want DLP that protects tomorrow’s risks, not just yesterday’s email, this step-by-step guide is for you.

This episode turns fragile, manual Power Platform deployments into reliable, auditable CI/CD with Azure DevOps. We unpack the real failure points—misconfigured service connections, flaky agent pools, hidden Dataverse dependencies, missing connection references—and show how to fix them with hardened service principals, right-sized agents, automated Solution Checker scans, and pre-deployment validations. You’ll get a pragmatic rollback/backup playbook (versioned solution exports, environment snapshots, and tested restore drills) plus pipeline patterns that catch issues early and ship consistently across dev → QA → prod. If you’re done gambling with imports that “worked in dev,” this step-by-step guide will make your deployments boring—in the best way.

This episode demystifies Power Platform ALM with GitHub Actions so you can see—and control—every step from source to prod. Learn why deployments fail (connector references, environment variables, and human-led imports), how to wire service principals and scoped secrets, and how to structure GitHub workflows (triggers, jobs, env-specific vaults) that validate, remap, and deploy solutions predictably. We cover source management with unpacked solutions, build-time checks, connector/variable remapping at deploy, and guardrails that stop silent breakages. If your Power Apps and flows “work in dev” but die in test or prod, this is your step-by-step playbook to ship reliable, auditable releases—without guesswork.

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.

This episode shows how Microsoft Fabric + Dynamics 365 Supply Chain Management (SCM) turn fragmented dashboards into a real-time, end-to-end control system. We connect purchase orders, production, inventory, transport, and delivery into one model that surfaces delays early, triggers automated responses, and powers “what-if” planning. You’ll see the reference blueprint—OneLake, Lakehouse, real-time pipelines, and Power BI—plus alerting, vendor scorecards, and KPI governance. If you’re done firefighting lost shipments, this is your playbook to get live visibility, faster decisions, and a supply chain that learns with every run.

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.