Forum Discussion
On-prem SQL Server/MySQL gateway visible in Dataflow Gen2 but NOT in Copy Job or copy data (Fabric)
Hello deekshi_03
Community Support has already responded to you about this behaviour.
"This situation is caused by a current limitation in Microsoft Fabric, rather than an issue with your gateway setup. Dataflow Gen2 and Copy Job use different backend engines: Dataflow Gen2 relies on the Power Query/Power Platform infrastructure, which fully supports classic on-premises data gateways, so the gateway appears and functions correctly there."
However you can try the following -
Verify permissions
- In Manage connections and gateways, add yourself (and the workspace) as gateway users and ensure Edit rights in the workspace. Lack of user binding can hide connections in the Copy assistant.
Use an Existing connection in Copy job
- In the Copy assistant, click View more / Existing connections and search for the connection you created in Manage connections and gateways; this often avoids re‑entering credentials and surfaces the gateway‑bound connection.
Restart the gateway service & refresh Fabric
- Restart PBIEgwService on the gateway host and refresh your browser; transient state can block discovery.
If this helped, kindly appreciate giving a Kudos or accepting as a Solution.
Hi deekshi_03,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!