topic Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL in Dataflow

Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

LuITS — Wed, 23 Apr 2025 14:46:44 GMT

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.

Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

miguel — Wed, 23 Apr 2025 14:51:49 GMT

Hi!

is your dataflow using a gateway by any chance ?

Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

LuITS — Thu, 24 Apr 2025 05:51:16 GMT

Hi,

Yes. I connect to the Oracle Database Via Gateway.

The Connection works with Dtaaflow Gen1. But not Gen2.

Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

miguel — Thu, 24 Apr 2025 11:15:35 GMT

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

Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

v-prasare — Mon, 05 May 2025 11:24:08 GMT

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

Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

LuITS — Tue, 06 May 2025 04:53:07 GMT

Hello, thanks for your reply. I haven't had the chance to customize the firewall yet.

Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

v-prasare — Mon, 12 May 2025 11:02:40 GMT

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

Re: Dataflow Gen2 Refresh Error: Gateway proxy unable to connect to SQL

v-prasare — Mon, 12 May 2025 11:56:10 GMT

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