Different connection types for Dataflow and Lakehouse

[joshua1990]

Hi!

I am about to built my first lakehouse. I wanted to ingest some data from impala.

The dataflow has as source type = impala and is based on an on-premise gateway.

The lakehouse has a different setup as you can see:

After publising and trying to ingest into lakehouse I get the following error:

Something went wrong, please try again later. If the error persists, please contact support.'. Error code: ActionUserFailure.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake

Is it required to have both connections wheter on-premise or cloud?

Or what else could be the issue here?

[v-pagayam-msft]

Hi @joshua1990 ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.

[v-pagayam-msft]

Hi @joshua1990 ,

I wanted to check and see if you had a chance to review our previous response. Please let me know if everything is sorted or if you need any further assistance.

Thank you.

[v-pagayam-msft]

Hi @joshua1990 ,
Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

[v-pagayam-msft · Accepted solution]

Hi @joshua1990 ,
Thank you lbendlin for the helpful insights!

The error likely occurs because return traffic from the Impala database server is being blocked by a firewall, despite outbound traffic from your gateway VM succeeding.As lbendlin suggested, please coordinate with your network team to adjust firewall settings for bidirectional traffic. Additionally, ensure your gateway is updated and authentication is configured correctly.

Hope this resolves yur query.If so,consider accepting it as solution.

Thank you for being a part of Microsoft Fabric Community Forum!

Regards,
Pallavi.

[lbendlin]

Looks like network traffic from your gateway VM to the Impala database server goes through but the return traffic gets dropped by one of the fitewalls. Talk to your network team.