Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
LuITS
Helper I
Helper I

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.

1 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

View solution in original post

7 REPLIES 7
v-prasare
Community Support
Community Support

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
Community Support
Community Support

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

miguel
Community Admin
Community Admin

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.