Microsoft Fabric: Load local SQL server data in Warehouse using Python, Pandas, and sqlalchemy

In this video of Microsoft Fabric, I will show to load data from an on-Premise SQL server to Warehouse using Python code with MFA. The Python code will use libraries Pandas, and sqlalchemy

Microsoft has Microsoft Fabric, the next-generation Analytic Platform. Check out how to enable it on Power BI Service. How to start a Fabric (Preview) trial
The Microsoft Fabric Platform provides customers with a SaaS-ified, open, lake-centric(One Lake), full-featured data, analytics, and AI platform that meets all their data estate needs. Power BI, Synapse Data Warehouse, Data Factory, Spark, and Notebook all under one platform

00:00 What we plan to do
02:00 Create a table in Warehouse
04:00 Where are the connection details
05:00 Understand the Python Code
12:30 Load the Data in Microsoft Fabric Warehouse
14:30 Check Data in Microsoft Fabric Warehouse

Code

🔵 What is Microsoft Fabric
Microsoft Fabric is an all-in-one analytics solution for enterprises that covers everything from data movement to data science, Real-Time Analytics, and business intelligence. It offers a comprehensive suite of services, including data lake, data engineering, and data integration, all in one place.

With Fabric, you don't need to piece together different services from multiple vendors. Instead, you can enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs.

Don't forget to like, comment, and subscribe for more great content!
▶️Data:

---------
▶️Follow me on:
---------
▶️My Other Videos:

-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
-~-~~-~~~-~~-~-

[Gerschk]

Hi Amit! thanks for all your work and dedication to the Fabric community! Question: will this work on a mac machine? I read that is only for window machines, and for mac is Either way, my attempt just keeps timing out. I'm writing this inside the Fabric notebook. And for the first part, I'm just loading a delta table from the lakehouse into pandas df.

[leandrochinelli]

First thanks for the stuff, it's the best thing about Microsoft Fabric so far!
Second, I would like to ask if there is any other way to connect with DW Fabric, so that I don't have to authenticate every time I run my python script.

[notoriousft]

This is a good one. I wonder if this can be achieved via Powershell or C#.

[faheemiftikhar]

Nice. Is it possible to load local sql server data in Lakehouse instead using Python. I have seen your video where you upload file but is it possible to use this approach and upload data into Tables in Lakehouse using python ?

[balajikomma]

Sir learning microsoft fabric will it give me more weightage to my job profile as a power bi developer

[avinayakchoudhary]

Please continue hindi series for fabric

[KnowDataAcademy-cj]

Hello,

(pyodbc.InterfaceError) ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified (0) (SQLDriverConnect)')

I am getting this error, as I am running this script into Notebook (Fabric), Help me to insert data into data warehouse with the help of Fabric Notebook.