Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. However, during this preview stage, Microsoft Fabric brings many surprises (and, should I say, deceptions?) in this area.
This blog may explain a lot, but I’m not bringing conclusions, but lot of questions. It will be a pleasure to hear your ideas in the comments, let’s talk about it.
How Azure Data Factory Works
In order to understand how everything got mixed, it’s important to understand how Data Factory works in relation to external data.
Data factory has dataflows and pipelines. The pipelines