Connections not showing for external user

[cdj]

Hi!

I am working for a customer in their tenant. I log in to their tenant as an external user. Which is kind of a mess to get to the right the tenant sometimes.

Normally I would make everything in a notebook, but I need to make use of an onpremise data gateway so I chose to use a Data Pipeline.

The account that owns the onpremise data gateway has made a connection to SQL server database and shared it with my account. And I can see the connection in the Manage connections and gateways page from the Settings menu. So far so good.

When I try to create a copy activity I cannot choose the connection. All the connections listed are the ones from my own tenant. I know I have the connections as previously stated. How can I solve this?

[cdj]

Hi @v-kongfanf-msft ,

Thank you for replying. I tried all those. Sometimes they do work. Sometimes it works just by clicking the refresh button.

I also tried using a different browser, even using a different computer.

[v-kongfanf-msft]

Hi @cdj ,

Problems are usually caused by insufficient privileges or incorrect tenant switching. Resolve the problem by following these steps:

• Force log out and log back in to the customer tenant.
• Check the connection and gateway sharing permissions.
• Manually enter a connection name or use a service principal.
• Assign the necessary Azure roles.

Best Regards,
Adamk Kong

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