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

[LuITS]

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.

[v-prasare]

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

[v-prasare]

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

[LuITS]

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

[v-prasare]

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

[miguel]

Hi!

is your dataflow using a gateway by any chance ? 

[LuITS]

Hi,

Yes. I connect to the Oracle Database Via Gateway.

The Connection works with Dtaaflow Gen1. But not Gen2.

[miguel · Accepted solution]

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