How to Load SQL Server Data into Microsoft Fabric

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

Hello Mahimaa29 

I written a blog on this. Can you please go through this Seamless Data Migration from On-Prem SQL Server to... - Microsoft Fabric Community It might  helps you. 

Please let me know if any additional info required.

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Hi Mahimaa29 ,

Thanks for reaching out to the Microsoft fabric community forum. Also thank you, suparnababu8  and tayloramy , for the detailed explanations and helpful references shared above.

Could you please confirm if the information provided has resolved your issue? If you require any further assistance, feel free to let us know and we will be happy to support you.

Thank you.

Hi Mahimaa29 ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.