Microsoft Fabric - On Premises data gateway connection is not connecting from Copy Activity

[Sathish133]

Hi Team,

Data Pipelines were running successfully but now it is started failing suddenly with the below error, 

Overview : We have Azure VM which is acting as On Premises Data Gateway and created ODBC system DSN inside Azure VM and also Microsoft On Premises data gateway software installed in Azure VM. ODBC connection created in Microsoft Fabric using the DSN and gateway.

Verified steps :

On Premises Data Gateway status is Online in Microsoft Fabric.

Connection status is Online in Microsoft Fabric.

Azure VM (On Premises machine) is Running status.

ODBC system DSN is tested in Azure VM and test is successful.

Can you suggest on this.

[v-sathmakuri]

Hi @Sathish133 ,

Thank you for you response!! As the issue is resolved, please mark the helpfull reply Accept as solution. This will be helpful for other community members who have similar problems to solve it faster.

[v-sathmakuri]

Hi @Sathish133 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[Sathish133 · Accepted solution]

Hi Team,

I have downloaded the new version of Microsoft On premise Gateway and Updated the new version in the host.

After that, it started working.

[v-sathmakuri]

Hi  @Sathish133  , 

As the issue is resolved, could you please accept the helpful solution as answer. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[v-sathmakuri]

Hi  @Sathish133 ,

Thank you for reaching out to Microsoft Fabric Community.

Test connectivity from the Azure VM:

Test-NetConnection eu.frontend.cloudatahub.net -Port 443
If it fails, check NSG/firewall/proxy settings.

Ensure DNS resolves:

nslookup eu.frontend.cloudatahub.net

If this fails, the DNS settings on the VM or VNET might need correction.

After verifying connectivity, restart the gateway service on the VM by opening services.msc and restarting the On-premises Data Gateway service.

Update the gateway to the latest version.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!