How To Connect To On-Premises Data In Microsoft Fabric

Learn how to effortlessly connect and visualize your on-premises data using Microsoft Fabric Lakehouses. Discover the seamless process of establishing a secure connection to your data sources within your organization's network. Ensure that you have a data gateway installed on your machine to be able to follow along and load your on-prem data to the cloud into Fabric!
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Austin30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️TH-cam: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@Kinnoshachi]

How do you keep it flowing and up to date?

[@udendors]

Very helpfull and direct with no fuss.

[@PragmaticWorks]

Happy to hear the video was helpful, thank you for the comment!

[@valentinloghin4004]

Very nice many thanks !! It will be possible to copy files from a folder located on premise too ?

[@austinlibal]

That is correct. You can connect with an on-premises file system using a gateway.

[@lerbous4633]

can we use the copy data in Synapse Data Engineering method connect to on Prem SQL Server too? Cause i try with that method test connection unsuccessfull

[@austinlibal]

Currently the ability to work with the On-Premises Data Gateway in Fabric is restricted to only utilizing Dataflows Gen2. Support for this with the copy data activity in the Data Factory pipeline experience is on the roadmap and will be coming at some point in 2024.
You do have the ability to use a traditional Azure Data Factory or Azure Synapse Analytics pipeline to connect to your on-premises network with a Self-Hosted Integration Runtime and set the Sink property to the Fabric Lakehouse. This is a valid workaround for now!

[@vishwassee]

Is there a way to connect to on-prem SQL server using Fabric Notebook?

[@austinlibal]

Sure
Notebooks are all code so you just have to create the connection and get all the details in your language of choice.

[@majeedadil777]

Thanks for sharing. How to load data using data factory instead of Data Flow G2?

[@austinlibal]

Data Factory pipelines currently don’t support connection with the data gateway in Fabric.
Instead you could load on-premises data via the traditional data factory experience in Azure with a Self Hosted IR to the Fabric Lakehouse or Warehouse.

[@ewoutlagendijk9604]

@@austinlibal I am glad it doesn't support worrying :D

[@austinlibal]

@@ewoutlagendijk9604 🤣 I fixed it. Thanks!

[@AbiolaSingHymns]

This is completely incomplete and not useful video as you did not cover the important part of how you downloaded the Data Gateway and set up up. How do you think an average users will understand how to successfully connect to on premises data?

[@satellitepop]

The most important information was missing, how to configure the Gateway and how to schedule refreshes. Sorry, this video is not worth it, a waste of time.

[@amal7411jo]

useless video he just ingorned the main part how to setup the gate way in local machine