topic Re: Tcp Error Dataflow Gen2 - Rest API to Warehouse in Dataflow

Tcp Error Dataflow Gen2 - Rest API to Warehouse

JDT — Tue, 15 Oct 2024 07:45:53 GMT

Hi,

we always get the following error message when we try to add a destination (Warehouse and Lakehouse) to our dataflow:

Something went wrong while retrieving the list of tables. Please try again later.: An exception occurred: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Session ID: 3febcc13-7756-427d-b213-973978a414a4, Region: europe)

Or it errors out with Unknown Error

The dataflow reads some data from REST APIs - everything seems fine in the preview. No on-prem gateway is involved.

Any tips ?

Re: Tcp Error Dataflow Gen2 - Rest API to Warehouse

lbendlin — Tue, 15 Oct 2024 12:29:01 GMT

No on-prem gateway is involved

You would think that. But that's not how they set it up.

Configure proxy settings for the on-premises data gateway | Microsoft Learn

Re: Tcp Error Dataflow Gen2 - Rest API to Warehouse

frithjof_v — Tue, 15 Oct 2024 22:50:55 GMT

Does it work if you use another Dataflow to query the first Dataflow, and write to destination?

I.e. API -> Dataflow -> Dataflow -> Destination