Forum Discussion
Solved
On-prem gateway firewall rules?
Hi, we're hitting issues trying to load data from an on-prem SQL server database to Fabric. It appears that our on-prem gateway servers need to be able to talk to the SQL endpoints, which they curren...
Hi ScottPowell ,
Had exactly the same issue.
I found most of confirmation in Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
We've just added *.datawarehouse.pbidedicated.windows.net and allowed communication on 1433.
Having pinged it it also seemed to redirect to *.uksouth.cloudapp.azure.com so I asked IT to add that at the same time to avoid messing them around although don't think that's strictly needed.
It is however now fully working.Ben
The dataflow gen 2 working with On-Prem is too troublesome. I think they need to focus on the context of on-Prem. Other than On-prem, it is nice functioning.