topic Re: Gen2 Dataflows can't load data into Lakehouse in Dataflow

Gen2 Dataflows can't load data into Lakehouse

caomayan — Tue, 16 Jul 2024 13:56:18 GMT

Hi folks,

We are trying to load data using on-prem gateway from Dataflow gen2 to lakehouse, but encountered the issue, even we open the firewall rule on these endpoints on gateway servers:

*.datawarehouse.pbidedicated.windows.net 1433
*.datawarehouse.fabric.microsoft.com 1433

*.dfs.fabric.microsoft.com 1433

The error message is showing below no matter with non-gateway or gateway lakehouse connection, is there anything we have missed?

Appreciate for any help!

Re: Gen2 Dataflows can't load data into Lakehouse

Anonymous — Wed, 17 Jul 2024 01:37:02 GMT

Hi caomayan

Despite having the necessary firewall rules turned on, you are still experiencing problems connecting to Lake Warehouse One.

This error message indicates that the connection was established, but failed during the login process due to an SSL provider error.

You can try the following steps:

Ensure that the local data gateway has been updated to the latest version. Sometimes, updating the gateway can solve similar problems.

Verify that the SSL/TLS settings on the gateway and server are properly configured. This error message indicates an SSL-related problem, so ensuring the correct protocol and certificate may be helpful.

Check the logs on the local data gateway for any other error messages or clues that may help diagnose the problem.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Gen2 Dataflows can't load data into Lakehouse

caomayan — Wed, 17 Jul 2024 14:29:09 GMT

Thanks a lot Nono for the reply! I'll upgrade the gateway to the latest version and try again

Re: Gen2 Dataflows can't load data into Lakehouse

Anonymous — Fri, 19 Jul 2024 08:08:37 GMT

Hi caomayan

Can you tell me if your problem is solved? If yes, please accept it as solution.

Regards,

Nono Chen

Re: Gen2 Dataflows can't load data into Lakehouse

caomayan — Fri, 19 Jul 2024 12:43:26 GMT

Unfortunately the issue was not fixed yet, we upgraded the gateway version, checked the log with MS support, server team has just applied the TLS protocal on the gateway, we are still investigating