She-Ra and the Masters of the Dataverse
Proposed session for SQLBits 2026TL; DR
By the power of OneLake! Learn how to link Dataverse to Fabric and use Copy job for fast, reliable replication. Discover when to choose Copy job, handle incremental loads, and cut costs—your path to mastering Dataverse starts here!
Session Details
By the power of OneLake! In this fast-paced, demo-first session, we’ll battle the chaos of operational change in Microsoft Dataverse and emerge as true Masters of the Dataverse.
We’ll show how to link Dataverse to Fabric, then wield Copy job to replicate inserts, updates, and deletes into your analytics estate (and beyond) with minimal friction.
You’ll see when to choose Copy job over pipelines, how incremental and CDC patterns keep your data fresh, and the guardrails that make the experience reliable at scale.
We’ll also cover selective loads, the right authentication model, scheduling and monitoring tips, and common pitfalls you can avoid before Skeletor shows up in your run history.
If you need a simple, robust path from Dataverse to Lakehouse and downstream destinations, this session hands you the sword.
You’ll learn how to:
Link Dataverse to a Fabric Lakehouse and use it as a high-fidelity source for replication.
Use Copy job for bulk and incremental loads, and understand how CDC replication fits into your strategy.
Save costs by using Copy job over Fabric Link and the storage costs associated with it.
We’ll show how to link Dataverse to Fabric, then wield Copy job to replicate inserts, updates, and deletes into your analytics estate (and beyond) with minimal friction.
You’ll see when to choose Copy job over pipelines, how incremental and CDC patterns keep your data fresh, and the guardrails that make the experience reliable at scale.
We’ll also cover selective loads, the right authentication model, scheduling and monitoring tips, and common pitfalls you can avoid before Skeletor shows up in your run history.
If you need a simple, robust path from Dataverse to Lakehouse and downstream destinations, this session hands you the sword.
You’ll learn how to:
Link Dataverse to a Fabric Lakehouse and use it as a high-fidelity source for replication.
Use Copy job for bulk and incremental loads, and understand how CDC replication fits into your strategy.
Save costs by using Copy job over Fabric Link and the storage costs associated with it.
3 things you'll get out of this session
Link Dataverse to a Fabric Lakehouse and use it as a high-fidelity source for replication.
Use Copy job for bulk and incremental loads, and understand how CDC replication fits into your strategy.
Save costs by using Copy job over Fabric Link and the storage costs associated with it.
Speakers
Laura Graham-Brown's other proposed sessions for 2026
"Low Code, High Chaos: Taming the Shadow IT Beast" - 2026
Boost Power BI Productivity with TMDL Libraries - 2026
Centre of Excellence: Your Governance Superheroes Assemble! - 2026
Copilots, Chaos and Control: Getting Real About AI Productivity - 2026
Fabric Data Agents vs. Copilot Studio - 2026
Microsoft Fabric Activator and Power Automate - a great combination - 2026
Microsoft Fabric and the mess of SharePoint - 2026
Translytical Flows vs Embedding a Power App in your report - 2026
Why should we care about adoption? - 2026
Mark Pryce-Maher (He / Him)
medium.com/@sqltidy
Mark Pryce-Maher (He / Him)'s other proposed sessions for 2026
Building your own Fabric Open Mirroring Solution - 2026
F is for Fabric - 2026
Fabric COPY JOB solved by the Mystery Machine - 2026
Fabric for Muppets - 2026
Open Mirroring: Rick and Morty’s Guide to Zero‑ETL Across the Multiverse - 2026
SQL Server 1.0 Mirroring - 2026
SQL Server Mirror Mirror on the Wall… - 2026