Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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
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.
Solved! Go to 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
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
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!
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
3 | |
1 | |
1 | |
1 |