topic Re: On Premiese Data Gateway Not working in Data Piplines but works in Data Flow in Pipelines

On Premiese Data Gateway Not working in Data Piplines but works in Data Flow

surangatj — Tue, 25 Jun 2024 09:43:28 GMT

Hi Team,

I have create a Data gateway and i have succefully connected to my SQL server 2016 data source via setting and created a connection and everthing got sucess. but when i want to connect the same connection or create a connection using that data gateway or a new data gateway it gives me an error. Error as below;

Please check your network connectivity to ensure your on-premises data gateway can access sea.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved.

But from the same connection it works in Data Flow but not in Data Piplines. Can you help me with this?

Thanks in Advance.

Re: On Premiese Data Gateway Not working in Data Piplines but works in Data Flow

v-cboorla-msft — Wed, 26 Jun 2024 06:54:59 GMT

Hi surangatj

Thanks for using Microsoft Fabric Community.

To ensure optimal performance, it would be beneficial to confirm the version of your on-premises data gateway?

If you are using an older version, upgrading to the latest release might improve the data ingestion process.

For latest version of on-prem gateway please refer : On-premises data gateway

If the issue still persists, please do let us know. Glad to help.

I hope this information helps.

Thank you.

Re: On Premiese Data Gateway Not working in Data Piplines but works in Data Flow

surangatj — Wed, 26 Jun 2024 07:12:57 GMT

Hi v-cboorla-msft ,

Im using June 2024 update (3000.226.5) it works with the data flow but not with the Piplines. I have followed these instructions as per this link.

https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data

Let me know what to do.

Re: On Premiese Data Gateway Not working in Data Piplines but works in Data Flow

v-cboorla-msft — Thu, 27 Jun 2024 12:41:46 GMT

Hi surangatj

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

Re: On Premiese Data Gateway Not working in Data Piplines but works in Data Flow

v-cboorla-msft — Mon, 01 Jul 2024 05:53:32 GMT

Hi surangatj

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thank you.