Forum Discussion
Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL
Hello when trying to refresh a Dataflow gen2 i get following error.
Gateway proxy unable to connect to SQL.
The Dataflow connects to a oracle databse over a on premises data gateway.
In the query editor i can see the data of the database and transform it.
Why do i get this error when tyring to refresh the dataflow.
Data Destination is the default dataflow lakehouse.
This article may help:
https://learn.microsoft.com/en-us/fabric/data-factory/gateway-considerations-output-destinations
You may have a firewall rule blocking the gateway from communicating with the Fabric service to complete the process
7 Replies
Hi!
is your dataflow using a gateway by any chance ?
Hi,
Yes. I connect to the Oracle Database Via Gateway.
The Connection works with Dtaaflow Gen1. But not Gen2.
This article may help:
https://learn.microsoft.com/en-us/fabric/data-factory/gateway-considerations-output-destinations
You may have a firewall rule blocking the gateway from communicating with the Fabric service to complete the process
Hi LuITS,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Hello, thanks for your reply. I haven't had the chance to customize the firewall yet.
Hi LuITS,
As we haven’t heard back from you, did you got any chance to verify this?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Hi LuITS,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
