Forum Discussion
MS Fabric Data Flow Gen2. Can I write to an on-premise SQL Server?
I have setup a simple DataFlow to copy a table from an on-premise DB2 server. Within the Power Query interface, I can add a data destination (for copying the data to), but there are only 4 options t...
I can appreciate your frustration 😀. Colleagues have commented that DataFactory within Fabric is "watered down" in terms of its features/functions...not sure if that comment is valid, as I'm not, by any means, qualified to comment on that.
BUT...can anyone advise if a Fabric Gen2 Dataflow (or any other mechanism is available in Fabric) that can write data to a "non-Fabric based" data repository; in this case, an on premise SQL Server database? Thank you.