Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor


How to Connect lake house to local MS SQL


@Mohammed- It's as simple as using a copy activity in Azure Data Factory, you need to use `Copy data using pipeline` in Microsoft Fabric.

After create Lake house, there is an option to get data and select new data pipeline.


After create Data warehouse, there is an option to get data and select new data pipeline.


Then, choose the data source you want as SQL server from databases and the configure.


For more information, refer to below links:

Load Sample data to Data Warehouse

Quickstart: Create your first pipeline to copy data

Demo on The Ultimate Data Warehouse experience in Microsoft Fabric

Hope this helps.

Super User
Super User

@Mohammed- I guess you are referring to use SSMS

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

November Fabric 2023 Webinars

Fabric Monthly Update - November 2023

Check out the November 2023 Fabric update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Get Help with Synapse in the General Discussion Forum

General Discussion Forum

Ask your questions about Synapse here!

Top Solution Authors