Forum Discussion
Get data connected to dataflow gen 2 source
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! 🙂
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.
Hi Anonymous,
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
Does your table in the Dataflow Gen2 have staging enabled?
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!
