Data Governance Episodes

Fabric Dataflows Gen2 redefine how ETL processes are built and managed inside Microsoft Fabric. Unlike legacy Power BI Dataflows, Gen2 introduces scalable, reusable, and Lakehouse-integrated data transformation capabilities designed for enterprise-grade analytics environments. In this guide, we explain how Fabric Dataflows Gen2 work, how they integrate with OneLake and Lakehouse architecture, and when to use them instead of pipelines or notebooks. Whether you're modernizing your ETL strategy or building a new Fabric-based data platform, this breakdown helps you understand the architectural impact and governance considerations of Gen2 Dataflows. If you're building scalable, maintainable ETL inside Microsoft Fabric — this is essential reading.

Stop exporting Dynamics 365 data to Excel. Connect Dataverse to Microsoft Fabric, build an analytics model once, and embed Power BI directly inside Dynamics 365 (CRM/ERP) screens. With live, role-aware metrics (RLS), sales and ops teams act on fresh data without tab-switching, stale snapshots, or version drift. Use Fabric Data Factory/Dataflows Gen2 to shape data, enforce security with Entra ID and sensitivity labels, and place context-specific visuals in forms and dashboards. Result: faster decisions, fewer reconciliations, and a proactive, in-app analytics loop.

Auditing user activity in Microsoft 365 is no longer optional — it’s essential for security, compliance, and governance. Microsoft Purview provides powerful audit capabilities, but many organizations don’t use them correctly or fail to leverage advanced logging features. In this guide, we walk through how to enable auditing in Microsoft Purview, how to search and analyze audit logs effectively, and how to use audit data for threat detection, compliance investigations, and risk mitigation. Whether you're investigating suspicious behavior, preparing for a compliance review, or strengthening your security posture, this step-by-step breakdown shows you how to turn audit data into actionable insight.

Stop guessing where your data went. In Microsoft Fabric, automatic lineage, workspace-based permissions, and Purview’s enterprise catalog turn opaque pipelines into auditable, end-to-end flows—from ingestion to transformation to the report. Fabric captures every hop (Data Factory, Lakehouse, notebooks/SQL/Dataflows, semantic models, Power BI), enforces access consistently via workspace inheritance, and records who changed what and when. With Purview cataloging and classifications on top, you can search sensitive fields across workspaces, prove compliance with unified audit logs, and fix broken KPIs fast—without chasing email threads or exporting mystery CSVs.

Stop waiting on dashboards. Fabric Data Activator turns live signals into instant actions—pausing bad pipelines, placing purchase orders, opening D365 work orders, or triggering API calls the moment thresholds hit. Because it’s native to Microsoft Fabric, it listens to streams and models from Power BI, Synapse, and the Lakehouse, then executes pre-approved playbooks with minimal latency. Start small with high-value triggers, design for capacity and downstream SLAs, and wire in guardrails so you get signal—not alert spam. That’s how you move from data-driven to data-activated.

Stop torturing your laptop. Train models where the data lives. With Microsoft Fabric notebooks running on Spark next to your Lakehouse, you skip CSV exports, move terabytes at query speed, and iterate in Python or R without memory crashes. Push transforms to the data, engineer features at scale, monitor long runs in real time, checkpoint models, and evaluate across massive test sets—cutting days of wrangling into hours of results.

Dataverse “slowness” is often schema, not size. Fix table bloat, simplify relationships, and add the right indexes to turn crawling forms and timing-out flows into crisp responses. Design for performance from day one—balance normalization, limit cascades, and index what you filter on.

Viva Topics can surface gold—or noise. Turn AI guesses into trusted answers by triaging topics in week one, curating only what matters, merging duplicates without losing links, and designing rich, action-first topic cards. With the right governance, SMEs, and analytics, people stop “searching” and start finding.

Manual SharePoint reviews don’t scale. Use PnP PowerShell + Microsoft Graph + Azure Automation to enumerate every site, expand nested/group/inherited permissions, and deliver a clean, daily report. App-only auth, throttling-safe queries, and diff alerts turn a weeks-long audit into an automated, trustworthy pipeline.

Viva Connections can be more than a pretty SharePoint homepage. Pair a solid foundation (navigation, targeting, permissions, mobile) with SPFx web parts and Adaptive Card Extensions (ACEs) to surface live business data and actions inside Teams. Build tiles that do work—approve, submit, track—then drive adoption with role-based personalization, performance discipline, and a measured change plan.

Stop context-switching. Embed Dynamics 365 Sales directly into Microsoft Teams so reps update opportunities, trigger approvals, and log notes where they already work. Layer Power Automate and Adaptive Cards to turn chats into actions (create/update/approve) and keep CRM as the single source of truth. Result: faster deal cycles, cleaner data, fewer misses.

Most Power BI environments start fast and stall under copy-paste sprawl: duplicated PBIX files, conflicting measures, and “spreadmart” dashboards that nobody fully trusts. The fix isn’t another naming convention—it’s a model-first architecture. Microsoft Fabric elevates the semantic model to an enterprise asset: one definitional layer reused across reports, workspaces, and teams. Pair that with calculation groups to eliminate endless YTD/QTD/TTM variants and keep time intelligence, KPIs, and business rules centralized and auditable. Add row-level security in the model to deliver true governed self-service—users explore freely while access is enforced automatically by role and region. The result: fewer datasets, consistent metrics, faster updates, and a BI stack that scales without chaos. If you’re tired of DAX drift and number debates, Fabric’s semantic models + calc groups + RLS turn scattered reports into a trustworthy analytics backbone.

Microsoft Fabric Lakehouse environments enable unified analytics across structured and unstructured data — but performance optimization is critical to ensure scalability, cost control, and reliable reporting. In this guide, we break down how to optimize Lakehouse performance in Microsoft Fabric, including data modeling strategies, partitioning best practices, query tuning, workload management, and storage optimization. Whether you're working with large datasets, real-time analytics, or enterprise reporting, these practical recommendations help you prevent bottlenecks and improve overall system efficiency. If your Fabric Lakehouse feels slow, unpredictable, or expensive — this is where to start.

Microsoft Fabric pipelines often feel “secure by default,” but silent data exposure usually comes from misconfigured permissions, hardcoded secrets, and overbroad workspace roles. This episode shows how to harden end-to-end pipelines with managed identities (kill passwords), Azure Key Vault (centralize and audit secrets), and precise RBAC (least privilege at workspace, pipeline, and dataset layers). You’ll learn where Fabric inherits risky defaults, how tenant/workspace access quietly widens, and the exact steps to lock down connectors, notebooks, and pipelines—without slowing your teams. Walk away with a practical security playbook, audit-ready logging, and guardrails that let admins, analysts, and engineers move faster with less risk.

Low-code does not mean low risk. Power Apps and Dataverse sit at the center of many business-critical processes, so skipped testing leads to silent data loss, broken approvals, and security leaks. This episode shows how to build a real testing strategy for the Power Platform: automate end-to-end scenarios across roles and environments, validate Dataverse business rules and flows, and wire tests into CI/CD with tools like EasyRepro and the Power Platform CLI. Learn why manual UAT misses dynamic UI, security role differences, environment variables, and connector drift—and how automated tests catch them before production. Walk away with a practical framework, checklists, and KPIs to accelerate delivery while protecting data quality, compliance, and trust.

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.

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.

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.

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.

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 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 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.