Forum Discussion
How to Load SQL Server Data into Microsoft Fabric
Hello Mahimaa29
there will be migration assitanct where you can migrate all these. Can you please go through this documetation Migrate Data with the Migration Assistant for Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn It might helps you.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Super UserHi Mahimaa29,
You’ve got a few good options to bring on-prem SQL Server data into Microsoft Fabric. The right choice depends on whether you need one-time/batch loads, continuous sync, or light-ETL Power Query. Below is a quick decision guide, then a deeper dive with pros/cons and setup tips.
- Need simple, GUI-based ETL? Use Dataflow Gen2 (Power Query) through the on-premises data gateway to land data in a Lakehouse/Warehouse. Docs
- Need scheduled copy at scale? Use Data Factory Pipelines > Copy activity with the SQL Server connector via the gateway.
- Need near-real-time, low-latency replication? Use Fabric Mirroring for SQL Server (preview/features evolving). Requires the on-premises data gateway and has specific prerequisites/limitations. Overview | SQL Server mirroring | Limitations
- Notebooks from Fabric to on-prem? Notebooks don’t traverse the on-prem gateway via JDBC; use Dataflows/Pipelines to ingest first, then notebooks process data inside Fabric. Community guidance reflects this behavior. Community thread
- First step for any on-prem option: Install and register the on-premises data gateway (Enterprise) on a server that can reach SQL Server, then create a Fabric Connection that uses that gateway. Install gateway | Use with Fabric
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.