Forum Discussion
Gen2 Dataflows suddenly failing
Magically things started working again.
Because magic.
Hi!
id recommend reaching out to the support team by raising a support ticket so our team of engineers can take a closer look at your specific Dataflows:
motoray Thanks to some guidance from MS engineers, we finally stumbled on the solution and it is : DO NOT FOLLOW the instructions from Microsoft documentation here: On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
My sysadmin had added all 3 endpoints to the FW rules and it didn't work. In fact, deleting them and their respective rules, and replacing them with one rule for the MS-SQL Server service TCP/1433 fixed everything!
DATAFLOW and ON-PREM DB connectivity solution - Microsoft Fabric Community