1

I am working with microsoft fabric and I need to create a data pipeline to extract information from a folder located on an onpremise server, but I don't see any connector from fabric that allows me to connect to this source onpremise, how can I do this?

willy sepulveda
  • 159
  • 1
  • 14
  • Question: what is your on-prem data, is it SQL or csv/ any other file format? – Sally Dabbah Jul 06 '23 at 06:35
  • You'll need some sort of Self Hosted Integration Runtime and normal Azure Data Factory pipeline to get your data from On Prem to the fabric storage account. Or use AZCopy to move data from your on prem to the cloud. – Jon Jul 11 '23 at 13:10

1 Answers1

0

If you are using pipelines ,You need to get your data to Fabric Lakehouse

  1. create Lakehouse following this link: https://learn.microsoft.com/en-us/fabric/data-engineering/tutorial-build-lakehouse
  2. Load your on-prem files to Lakehouse

enter image description here

  1. After loading your data into lakehouse ,in lakehouse click on create a pipeline:

enter image description here

  1. add activity - lets assume copy activity -> select Lakehouse and choose your file.

enter image description here

if you're using data flows - try using dataflow gen 2 and here you can see on-prem data sources enter image description here

Sally Dabbah
  • 411
  • 2
  • 8