My on-prem data gateway is not showing in the Installed Instance list in the Azure Portal

Question

My on-prem data gateway is not showing in the Installed Instance list in the Azure Portal

Sara Lane 56

I installed an on-prem data gateway on my on-prem server. I then tried creating a corresponding data gateway in my Azure portal but the local installation is not showing in the list to select. I used the same login for both the local installation and the Azure portal. How can I connect my local on-prem gateway to my Azure portal?

Shravan Addagatla 1,440 Reputation points Microsoft External Staff Moderator

2025-06-06T11:46:07.59+00:00

Hi Sara Lane

In addition to the Alex response, which Azure service (like Logic Apps, Power BI and PowerApps) you would like to integrate with this on-prem data gateway?
Sara Lane 56 Reputation points

2025-06-08T20:39:22.93+00:00

I'd like to integrate with Azure Data Flow.
MD ANOWARUL ISLAM 0 Reputation points

2025-06-13T04:36:27.15+00:00

Thanks for the update on the greatest
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Accepted answer

1 additional answer

Your answer

Shravan Addagatla 1,440 Reputation points Microsoft External Staff Moderator

2025-06-06T11:46:07.59+00:00

Hi Sara Lane

In addition to the Alex response, which Azure service (like Logic Apps, Power BI and PowerApps) you would like to integrate with this on-prem data gateway?
Sara Lane 56 Reputation points

2025-06-08T20:39:22.93+00:00

I'd like to integrate with Azure Data Flow.
MD ANOWARUL ISLAM 0 Reputation points

2025-06-13T04:36:27.15+00:00

Thanks for the update on the greatest
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

Smaran Thoomu 24,015 Microsoft External Staff Moderator

Hi @Sara Lane
Currently, Azure Data Factory (ADF) and Mapping Data Flows do not use the On-premises Data Gateway. Instead, ADF relies on the Self-hosted Integration Runtime (SHIR) for accessing on-premises data sources.

Here's what you need to do:

If your intention was to use the gateway with ADF, please make sure you’ve installed and configured the SHIR, not the On-premises Data Gateway.

You can download and install the SHIR from the ADF portal itself:

In ADF, go to Manage > Integration Runtimes > + New > Self-hosted.
Follow the steps to install and register the SHIR using the same authentication account.

Note: The On-premises Data Gateway is used with Power BI, PowerApps, Logic Apps, etc., but not with ADF.

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Sara Lane 5 Reputation points

2025-06-10T07:56:59.9433333+00:00

Thank you for your informative response.

I tried setting up the on-prem gateway based on the answer I received here: https://learn.microsoft.com/en-us/answers/questions/2184452/how-can-i-send-data-from-an-azure-function-app-usi?page=1#answer-1949628:~:text=4%3A59%20AM-,The%20best%20way,-to%20send%20updates

Is that the best way of doing things?

Thank you!
Smaran Thoomu 24,015 Reputation points Microsoft External Staff Moderator

2025-06-10T08:30:09.2566667+00:00

Thanks for sharing the link, @Sara Lane
The approach mentioned in that thread - using the On-premises Data Gateway with Azure Function App and Power BI - is valid for Power Platform scenarios, where services like Power BI or Logic Apps communicate with on-prem resources through the gateway.

However, in your case, since you're working with Azure Data Factory (especially Mapping Data Flows), the On-premises Data Gateway won't work.

For ADF, the recommended and supported method is to use the Self-hosted Integration Runtime (SHIR). This is purpose-built for securely accessing on-prem data sources from ADF pipelines and data flows.

I hope this information helps. Please do let us know if you have any further queries.
Sara Lane 5 Reputation points

2025-06-10T08:49:34.0533333+00:00

I just want to be able to send updates from my Azure SQL table to my on-prem SQL database. Do you recommend ADF + SHIR for that? Or would you recommend something else?
Smaran Thoomu 24,015 Reputation points Microsoft External Staff Moderator

2025-06-10T10:01:49.2966667+00:00
Sara Lane Yes, if your goal is to move or sync data from Azure SQL Database to your on-prem SQL Server, then Azure Data Factory (ADF) with a Self-hosted Integration Runtime (SHIR) is the recommended and most robust solution. Here's why:

ADF + SHIR supports secure, scheduled, and scalable data movement.

You can configure copy activities or data flows to push updates from Azure SQL to your on-prem SQL.

SHIR runs inside your network and securely connects to your on-prem SQL Server without opening inbound ports.

If your updates are event-driven or near real-time, other options like Azure Functions + Hybrid Connection or SQL change tracking with ADF triggers might also be explored, but ADF+SHIR is usually more manageable and scalable for recurring data sync.

I hope this information helps. Please do let us know if you have any further queries.
Sara Lane 5 Reputation points

2025-06-10T12:59:48.6133333+00:00

Thank you!

My updates are event-driven but according to the post I referenced above (and my own experimentation) Azure Functions + Hybrid Connection didn't work. I'll look into ADF triggers - thank you!
Smaran Thoomu 24,015 Reputation points Microsoft External Staff Moderator

2025-06-10T13:33:34.73+00:00

Sara Lane You're right - Hybrid Connections can be tricky for sending data out to on-prem SQL. Since your updates are event-based, using ADF triggers or change tracking in ADF could work well.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sara Lane 5 Reputation points

2025-06-10T13:50:59.2333333+00:00

Thank you!
Smaran Thoomu 24,015 Reputation points Microsoft External Staff Moderator

2025-06-10T16:46:53.2666667+00:00

Sara Lane If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Alex Burlachenko 8,315

hi Sara Lane

thanks for dropping this question, ok so u installed the onprem data gateway locally, but azure portal ain’t seeing hmmm, the key thing is, did u use the exact same microsoft account for both the local install and azure portal? like, no typos, no alternate emails, no personal vs work account mixup? pls check that, because if the logins don’t match, azure won’t recognize the gateway.

open the onprem data gateway app on ur server. go to the ‘service settings’ tab. see that ‘azure service bus’ checkbox? make sure its ticked. if it’s not, the gateway can’t talk to azure properly on-prem data gateway docs.

still no luck? try restarting the gateway service. sometimes it just needs a kick 8*) open ‘services.msc’, find ‘on premises data gateway service’, and hit restart. wait a minute, then refresh azure portal.

if it’s still ghosting u, uninstall and reinstall the gateway. yes, annoying, but it often fixes weird issues. just make sure u use the same account during reinstall. reinstall gateway.

and check ur firewall. the gateway needs outbound access to azure, so if ur company’s firewall is blocking it, nada. ports 443 and 5671-5672 gotta be open gateway firewall rules.

hope this helps Sara.

Best regards,

Alex

and "yes" if you would follow me at Q&A - personaly thx.
P.S. If my answer help to you, please Accept my answer
PPS That is my Answer and not a Comment

https://ctrlaltdel.blog/

Sara Lane 56 Reputation points

2025-06-08T20:38:23.7666667+00:00

Hello Alex,

Thank you very much for your helpful response.

Yes, I used the same email as I used for my portal login. But my portal login is not the root login although it has Owner permissions. It's also in a different tenant than the root login and is considered a guest, I hope that's not the issue.

Regarding the service bus checkbox, I see HTTPS mode under the Network tab, is that what you mean? Under the Service Settings tab I just see Restart the Gateway and Gateway Service Account.

I've tried restarting, uninstalling-reinstalling, and I also opened up those ports in the Firewall (plus 9350-9354 per the doc you referenced). The gateway is still not showing up.

Am I looking in the right place? I go to https://portal.azure.com/#create/Microsoft.ConnectionGatewayand expect my installation to show up under Installation Name but the list is empty.

Thank you!
Loknathsatyasaivarma Mahali 2,390 Reputation points Microsoft External Staff Moderator

2025-06-09T06:27:44.03+00:00

Hello Sara Lane,

The issue is likely due to a tenant mismatch. On-premises data gateways are tied to the Azure AD tenant of the account used during installation. If you're using a guest account from a different tenant (even with Owner permissions), the gateway won't show up in the Azure portal. To resolve this, make sure you install and access the gateway using a native account in the same tenant where you're trying to register it. You can either ask the admin to create a native user for you or switch to the correct directory in the portal (click your profile > Switch directory). Also, check under Monitor > On-premises data gateways in the portal to confirm visibility.

Share via

My on-prem data gateway is not showing in the Installed Instance list in the Azure Portal

1 additional answer

Your answer