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
In addition to setting a firewall rule, please upgrade to the latest Gateway (version 3000.178.9 released on June 15th). That should help address at least one class of errors involving output destinations and/or queries that depend on other staged queries.
Thanks.