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

Опубликовано: 07 Июль 2023
на канале: Amit Chandak Learn Microsoft Fabric, Power BI, SQL

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

Python code Link:

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

GIT File link -
All files:

Power BI - Azure Free Tier, Create Azure Data Lake Gen 2 and connect that in Power BI:

Get Azure SQL DB and Configure it on Power BI:

Official Document:
Video from GuyinaCube:
Buy a Microsoft Fabric subscription:
SKU:
Licenses:
Enable Fabric:

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.

How to enable Fabric, find details -
Microsoft Fabric licenses details -

Don't forget to like, comment, and subscribe for more great content!
▶️Please Subscribe:
▶️Data:
• Covid 19:
• Get The data and Pbix files on Github:
• DropBox files:

---------
▶️Follow me on:
• Medium:
• Twitter:
• LinkedIn:
---------
▶️My Other Videos:
• Mastering Power BI:
• Expertise Power BI:

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

-~-~~-~~~-~~-~-