On-prem SQL Server/MySQL gateway visible in Dataflow Gen2 but NOT in Copy Job or copy data (Fabric)

[deekshi_03]

I’m facing an issue while working with Microsoft Fabric related to on-premises data gateway visibility across different Fabric components.

Scenario

• I have installed and configured an On-premises Data Gateway on my machine.

• I have admin access to the gateway and workspace.

• I am using Microsoft Fabric (Free Trial) with a student email ID.

What works

• When I use Dataflow Gen2, I am able to:

  • Connect to on-prem SQL Server / MySQL

  • See and select the existing on-prem gateway

  • Successfully access and preview data

What does NOT work

• When I try to use Copy Job / Copy Data activity:

  • The existing gateway does NOT appear

  • Gateway dropdown shows None

  • I’m unable to select or reuse the gateway that works in Dataflow Gen2

Checks already performed

I have already verified the following:

• Required database drivers (MySQL / SQL Server) are installed

• Outbound firewall rules are allowed

• Gateway service is running and online

• Gateway is properly registered and visible in Dataflow Gen2

• I have full admin permissions on:

  • Gateway

  • Workspace

• Public network access and connectivity are validated

Despite all this, Copy Job does not recognize the gateway.

Can someone please clarify:

• Whether this is a known limitation

• Or if there are specific prerequisites for enabling gateway usage in Copy Job?

Any official references or workaround suggestions would be greatly appreciated.