On-premises data with Data Factory in Microsoft Fabric

Do you have on-premises data like a SQL Server? Want to leverage a pipeline within Data Factory in Microsoft Fabric? Patrick shows you have to get going and set that up!

How to access on-premises data sources in Data Factory for Microsoft Fabric


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#MicrosoftFabric #DataFactory #GuyInACube

[kevindoherty]

Can't wait for on-premises Oracle to be supported.

[Mr_Whipple]

Q: Hey Patrick, it’s great to see that we can do this via pipelines and dataflows with on prem but I’m having a difficult time figuring out how to get data from an onprem environment to a spark notebook.

Is this possible in the current state of fabric or can we only use data flows and pipelines for this currently?

[ericksarante]

I Love U my friend, i have de the entire mornig looking for a solution to migrated all table from my on premise SQl to frabric in i find thx XD

[VaidasMatkus]

This has a major bug. When copying to datalake, time zones are converted. This bug is known for about a month and still not resolved. There are at least few posts in MS Community. My issue is: SQL server stores all dates and times in UTC (without time zone information), but our server is not in UTC locale. All copied data is automatically converted to "local" time

[ManoshChanda]

From Fabric can i build views/generate Power BI Report on top of On Prem Data without really bringing in the data into LakeHouse or OneLake ? Or bringing the data into Lake House or Onelake is necessary to build Self Serviceable Power BI report on the On Prem data

[mkj]

Hello Patrick, I can see a folder (file) option in the data source of copy activity in Data pipeline. Are we able now to copy files form local machines one a data gateway connection of folder type is established? Will the files mentioned in that data source be unstructured or only structured semi structured?
Thanks

[jonclemens]

Great Vid! Do you have any idea if Data Mirroring will be enabled to a SQL server through the gateway?

[aghalarbayli]

Hi, Patrick. Thanks a lot for the video! I have used text analytics in power query, but it also asks for the gateway. I couldn't find anything suitable among "Connection Type", is there any way to make auto schedule refresh for reports use text analytics?

[ilseespinobarros]

Hi, I created a Pipeline in the same way as in this video and chose the option "Overwrite", however, everytime my pipeline runs, the data gets appended in the lakehouse table. Is this a bug that still needs to be solved? If not, could you please do a video for the Overwrite vs Append for On-Premises with an example?

[Stanwis]

This only copies data once or refreshes like with standard gateway connection?

[ppanch]

If I have an Analysis Services Cube on-premises. ¿How do I extract that data with the Data Pipeline?

[JustinGarcia-vmzr]

Does this require Fabric Capacity or can it work with PB Per User?

[VaidasMatkus]

It has a very annoying but that is not resolved for a month. It adds time by on prem timezone, so all timestamps are incorrect. Be aware before using

[PalantirM]

I’m a bit disappointed by this video: we already worked last
Month to injest data like this in Fabric.