Getting On-Prem data from SQL Server to Microsoft Fabric using Dataflow (gen2)

Dhruv_Ranpura so guys, ok so here's the deal (I am learning a lot about all this firewall stuff, hence why all the back and forth).  

port 1434 is irrelevant. 

One more thing for future readers:  The endpoint listed on the MS doc page (*.datawarehouse.pbidedicated.windows.net, *.datawarehouse.fabric.microsoft.com,  *.dfs.fabric.microsoft.com) are wildcard FQDNs.  So it depends on the firewall what you can or cannot setup from what I've been told.  

In our case, we specified the 0.0.0.0/TCP/1433 for outgoing traffic and that did the trick.

Oh man, what confusion... finally we got to an understanding. 😥  The Microsoft documentation should seriously be rewritten on this point, because the people who are going to read it are Fabric users, not network admins.