Get data connected to dataflow gen 2 source

[Yaroslava]

Hello,

I'm encountering an issue when trying to use data from an existing Dataflow Gen 2 table. The following error message appears:

---------- Message ----------
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 ----------
d8708cb2-697e-495f-8438-f2f994a786e7

---------- Request ID ----------
37196c58-7fbb-476c-b5b0-b207081f4d00

---------- Mashup script ----------
section Section1;
shared #"Dim Process Type" = let
Source = PowerPlatform.Dataflows([]),
#"Navigation 1" = Source{[Id = "Workspaces"]}[Data],
#"Navigation 2" = #"Navigation 1"{[workspaceId = "543caf0e-cfd5-464b-bc52-b1d84fa14f25"]}[Data],
#"Navigation 3" = #"Navigation 2"{[dataflowId = "7756c269-b4a0-4c77-8269-e061772ba175"]}[Data],
#"Navigation 4" = #"Navigation 3"{[entity = "Dim Process Type", version = ""]}[Data]
in
#"Navigation 4";
shared FactAmResult = let
Source = PowerPlatform.Dataflows([]),
#"Navigation 1" = Source{[Id = "Workspaces"]}[Data],
#"Navigation 2" = #"Navigation 1"{[workspaceId = "543caf0e-cfd5-464b-bc52-b1d84fa14f25"]}[Data],
#"Navigation 3" = #"Navigation 2"{[dataflowId = "039ace56-949f-42a7-9474-949b586d1136"]}[Data],
#"Navigation 4" = #"Navigation 3"{[entity = "FactAmResult", version = ""]}[Data]
in
#"Navigation 4";
shared Query = let
Source = PowerPlatform.Dataflows([])
in
Source;

_____________________________________________________________

What's interesting is that I can connect to regular Dataflows without any issues, but I'm unable to connect to Dataflow Gen 2. Additionally, I noticed that the Dataflow Gen 2 table does not appear to be in a table format.

Could you please assist me with this issue?

I would also like to mention that everything was working correctly a week ago, and I was able to connect to Dataflow Gen 2 tables without any problems.

Thank you for your support.

[Yaroslava]

Dear Fabric Team,

The issue is still unresolved.

I continue to receive the error, and it's unclear why the error message indicates a problem with the SQL connection, given that I try to connect to other Dataflow Gen 2 sources. I also find it confusing that I was able to work with Dataflow Gen 2 queries a few months ago, but now I can't even open them without encountering the error mentioned above.

Additionally, I don't understand why this issue only affects Dataflow Gen 2, while the basic Dataflows are working without any issues.

Thank you for your assistance.

[Yaroslava]

Hi,

It should be, as I was able to load data today using Dataflow Gen2 from another Dataflow Gen2 table without providing any additional setup.

Thank you, and have a nice day!

[Yaroslava · Accepted solution]

Hi,

It should be, as I was able to load data today using Dataflow Gen2 from another Dataflow Gen2 table without providing any additional setup.

Thank you, and have a nice day! 🙂

[v-yilong-msft]

Hi @Yaroslava ,

The error message you’re seeing, “The semaphore timeout period has expired,” typically indicates a network-related problem or a timeout issue during the connection process.

Here are a few steps you can try to resolve this issue:

1. Ensure that your network connection is stable and not experiencing any interruptions.

2. Check your firewall and security settings to ensure that they are not blocking the connection. Sometimes, security settings can interfere with the connection process.

3. If you are using SSL/TLS for your connection, ensure that the certificates are correctly configured and trusted. Misconfigured certificates can cause handshake errors. You can look at this document: Error message when you connect to SQL Server - SQL Server | Microsoft Learn

4. Sometimes, simply retrying the connection can resolve transient issues.

Best Regards

Yilong Zhou

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

[Yaroslava]

Hi @v-yilong-msft,

Should the firewall, security, or other setup topics be configured differently for base Dataflows and Dataflow Gen 2?

In my case, I need to create a query using Dataflow Gen 2, where the data source for this query is another table created with Dataflow Gen 2. I'm asking about security or other setup configurations because I can easily connect the source with a base Dataflow, but I receive an error when trying to connect the source with Dataflow Gen 2, even though I'm using the same connection.

Thank you for your feedback and your time.

Best Regards,
Yaroslava

[frithjof_v]

Does your table in the Dataflow Gen2 have staging enabled?

[Yaroslava]

Hi,

It should be, as I was able to load data today using Dataflow Gen2 from another Dataflow Gen2 table without providing any additional setup.

Thank you, and have a nice day!