Microsoft Fabric: Import On Premise SQL Server 2022 Data into Microsoft Fabric with Data Pipelines!!

Bradley Ball, aka @SQLBalls, walks us through how to install, setup, and configure a data gateway. Then how to register that data Gateway in Microsoft Fabric. We then use a Data Pipeline to import data from #SQLServer2022 into #MicrosoftFabric!

Chapters
00:00 Importing Data with Microsoft Fabric
01:21 Demo - Our SQL 2022 Data
01:42 Demo Install on-premises data gateway
02:31 Demo Configure SQL Server 2022 Connection
03:36 Demo Super Importaint Configure your ADLS Gen 2 Storage for Staging
03:57 Demo Create Data Pipeline
05:01 Demo Configure Staging
05:45 Demo Validate Data Import

Install an on-premises data gateway

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field

Bradley Ball

Daniel Taylor

Neeraj Jhaveri

Josh Luedeman

Andrés Padilla

[adilmajeed]

Thanks for sharing. When you have created the connection in the Fabric service and then you had clicked to see the properties again, after scrolling at the bottom, I can’t see the staging part in my connection which you had showed in the properties dialogue box. Power BI Gateway is already been updated. Any pointers…

[OneNI]

In this method can we bulk import tables (lets say we want tables that are filtered using a query and those tables we need to import), what would be the maximum that can export at one go ?

[vbhvprksh]

Where did you get that username and password from ??