Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
WhisperofCoding
Frequent Visitor

MashupException.Error: an error occurred during the pre-login handshake

Hi guys,

 

I keep receiving an error while fetching data with a Dataflow Gen2. I am trying to get data through our Gateway (version 3000.178.9) but keep hitting the same error over and over. 

I tried 2 options through the gateway:

- Receiving data from a database on a local SQL server (autorization is correct)

- Receiving data from csv file on our network

Both options gave the same errors.

 

We also use Power BI through this same gateway without any problems. 

I used 'My workspace', but also created a new workspace, still the same problems.

 

WhisperofCoding_0-1688550062870.png

 

WhisperofCoding_1-1688550115876.png

 

WhisperofCoding_2-1688550477606.png

 

Full error message:

Mashup Exception Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: 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.) Details: DataSourceKind = Lakehouse;DataSourcePath = Lakehouse;Message = 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.);ErrorCode = -2146232060;Number = 121;Class = 20 GatewayObjectId: xxxxxx

10 REPLIES 10
Joe_Doe
Frequent Visitor

Hi! Has anyone found a solution to this problem? I'm having the same pre-login handshake error for all my Gen2 Dataflows. Gen1 Dataflows work fine. Whether I'm using a lakehouse or a warehouse as the destination, the same thing happens. I've tried many ways to fix this, but to no avail. I opened a support ticket, and they didn't offer any solution. Their response is that it's network glitches. :S

SidJay
Microsoft Employee
Microsoft Employee

If you're using a Gateway could you please verify that port 1433 is open.

 

More details:
On-premises data gateway considerations for data destinations in Dataflow Gen2 - Microsoft Fabric | ...

 

Thanks

Joe_Doe
Frequent Visitor

Hi! Has anyone found a solution to this problem? I'm having the same pre-login handshake error for all my Gen2 Dataflows. Gen1 Dataflows work fine. Whether I'm using a lakehouse or a warehouse as the destination, the same thing happens. I've tried many ways to fix this, but to no avail. I opened a support ticket, and they didn't offer any solution. Their response is that it's network glitches. :S

SidJay
Microsoft Employee
Microsoft Employee

When a dataflow is bound to a Gateway, all the read and write operations are executed via the Gateway.

 

To transfer data from staging to a warehouse without using the Gateway, you would currently need a separate dataflow that is not bound to a Gateway.

 

Dataflows are either executed entirely in the Cloud or entirely on a Gateway. There isn't a blended mode.

 

Thanks

SidJay
Microsoft Employee
Microsoft Employee

Could you please confirm that the configuration that Miguel suggested earlier in the thread has been applied?

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

 

Additionally, Port 1433 needs to be opened. The documentation is being updated to include this.

 

Thanks

Am currently working with my IT folks to try and get that port opened. We'll see what they say.

 

I thought the whole point of the gateway is so you don't have to jump through these kinds of hoops--it's been pretty great up to now. And I still don't understand why the port needs to be opened if I'm getting data in the staging warehouse--at that point, isn't the next step just moving it from staging to the warehouse?

miguel
Community Admin
Community Admin

hey folks! Could you please read the article below and check if these proxy considerations have any impact on your scenarios?

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

AnthonyGenovese
Resolver III
Resolver III

I am having the same issue. It loads the data from on prem fine. You can see the data in the staging warehouse. However it doesn't write it to the Lakehouse correctly

Having the same issue here. Have tried everything I can think of--rebuilding the workspace and dataflows multiple times. I was able to load data from a Gen1 dataflow source into a Lakehouse, but can't get the onprem data to go from the staging lakehouse into the production lakehouse.

WhisperofCoding
Frequent Visitor

I also tried the gateway port test, that all came out with status 'Success':

Overall Results : 32/32 tests succeeded.

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

"); $(".slidesjs-pagination" ).prependTo(".pagination_sec"); $(".slidesjs-pagination" ).append("
"); $(".slidesjs-play.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-stop.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-pagination" ).append(""); $(".slidesjs-pagination" ).append(""); } catch(e){ } /* End: This code is added by iTalent as part of iTrack COMPL-455 */ $(".slidesjs-previous.slidesjs-navigation").attr('tabindex', '0'); $(".slidesjs-next.slidesjs-navigation").attr('tabindex', '0'); /* start: This code is added by iTalent as part of iTrack 1859082 */ $('.slidesjs-play.slidesjs-navigation').attr('id','playtitle'); $('.slidesjs-stop.slidesjs-navigation').attr('id','stoptitle'); $('.slidesjs-play.slidesjs-navigation').attr('role','tab'); $('.slidesjs-stop.slidesjs-navigation').attr('role','tab'); $('.slidesjs-play.slidesjs-navigation').attr('aria-describedby','tip1'); $('.slidesjs-stop.slidesjs-navigation').attr('aria-describedby','tip2'); /* End: This code is added by iTalent as part of iTrack 1859082 */ }); $(document).ready(function() { if($("#slides .item").length < 2 ) { /* Fixing Single Slide click issue (commented following code)*/ // $(".item").css("left","0px"); $(".item.slidesjs-slide").attr('style', 'left:0px !important'); $(".slidesjs-stop.slidesjs-navigation").trigger('click'); $(".slidesjs-previous").css("display", "none"); $(".slidesjs-next").css("display", "none"); } var items_length = $(".item.slidesjs-slide").length; $(".slidesjs-pagination-item > button").attr("aria-setsize",items_length); $(".slidesjs-next, .slidesjs-pagination-item button").attr("tabindex","-1"); $(".slidesjs-pagination-item button").attr("role", "tab"); $(".slidesjs-previous").attr("tabindex","-1"); $(".slidesjs-next").attr("aria-hidden","true"); $(".slidesjs-previous").attr("aria-hidden","true"); $(".slidesjs-next").attr("aria-label","Next"); $(".slidesjs-previous").attr("aria-label","Previous"); //$(".slidesjs-stop.slidesjs-navigation").attr("role","button"); //$(".slidesjs-play.slidesjs-navigation").attr("role","button"); $(".slidesjs-pagination").attr("role","tablist").attr("aria-busy","true"); $("li.slidesjs-pagination-item").attr("role","list"); $(".item.slidesjs-slide").attr("tabindex","-1"); $(".item.slidesjs-slide").attr("aria-label","item"); /*$(".slidesjs-stop.slidesjs-navigation").on('click', function() { var itemNumber = parseInt($('.slidesjs-pagination-item > a.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); });*/ $(".slidesjs-stop.slidesjs-navigation, .slidesjs-pagination-item > button").on('click keydown', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); var itemNumber = parseInt($('.slidesjs-pagination-item > button.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); }); $(".slidesjs-play.slidesjs-navigation").on('click', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); }); $(".slidesjs-pagination-item button").keyup(function(e){ var keyCode = e.keyCode || e.which; if (keyCode == 9) { e.preventDefault(); $(".slidesjs-stop.slidesjs-navigation").trigger('click').blur(); $("button.active").focus(); } }); $(".slidesjs-play").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-stop").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-play")) { $(".slidesjs-stop").focus(); } } }); $(".slidesjs-stop").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-play").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-stop")) { $(".slidesjs-play").focus(); } } }); $(".slidesjs-pagination-item").keydown(function(e){ switch (e.which){ case 37: //left arrow key $(".slidesjs-previous.slidesjs-navigation").trigger('click'); e.preventDefault(); break; case 39: //right arrow key $(".slidesjs-next.slidesjs-navigation").trigger('click'); e.preventDefault(); break; default: return; } $(".slidesjs-pagination-item button.active").focus(); }); }); // Start This code is added by iTalent as part of iTrack 1859082 $(document).ready(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); $("#tip2").attr("aria-hidden","true").addClass("hidden"); $(".slidesjs-stop.slidesjs-navigation, .slidesjs-play.slidesjs-navigation").attr('title', ''); $("a#playtitle").focus(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").mouseover(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").blur(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#playtitle").mouseleave(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#play").keydown(function(ev){ if (ev.which ==27) { $("#tip1").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); $("a#stoptitle").focus(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").mouseover(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").blur(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").mouseleave(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").keydown(function(ev){ if (ev.which ==27) { $("#tip2").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); }); // End This code is added by iTalent as part of iTrack 1859082
Top Solution Authors