topic Re: Cannot see the connection in Copy Activity in Pipelines

Cannot see the connection in Copy Activity

milosha — Tue, 05 Nov 2024 11:21:46 GMT

Hello,

we have a VNET Gateways and DB Connection set up, both are in Running state.

However when I create a Copy activity, the connection is not visible:

When I try to create a new connection, I cannot use the any gateway:

Not sure if it's important, but the VNET gateways were created by Azure Admin, but he delegated admin permissions on those gateways to me.

thanks for helping!

FabianSchut — Tue, 05 Nov 2024 22:40:27 GMT

Are the connections that are set up in Fabric also shared with you? In other words, are use assigned as a user to the data source? You can find the documentation to do this over here: https://learn.microsoft.com/en-us/fabric/data-factory/data-source-management#manage-users

milosha — Thu, 07 Nov 2024 13:15:56 GMT

Yes, I am owner of both the VNET Gateways and the connections built on top of them. I can check their status (Online).

FabianSchut — Thu, 07 Nov 2024 14:29:07 GMT

Can you share a screenshot of the settings of the gateway in Fabric?

milosha — Thu, 07 Nov 2024 16:56:20 GMT

So the issue is solved - Data Pipelines do not support VNET Gateway (yet, hopefully). Using Datataflow Gen2 the gateway is visible

Anonymous — Fri, 08 Nov 2024 05:33:38 GMT

Thank you very much FabianSchut for your prompt reply.

Glad to hear that your problem has been resolved. If you can, please accept it as a solution.

If you have other questions, please continue to post in this forum.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.