Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
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 ?
Does it work if you use another Dataflow to query the first Dataflow, and write to destination?
I.e. API -> Dataflow -> Dataflow -> Destination
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.