Fix Power Apps Cannot See On-Premises SQL Server Gateway
Question details
The user is unable to find the configured on-premises SQL Server data gateway in the gateway list when attempting to create a connection in Power Apps.
- Product
- Power Apps
- Device & OS
- not provided
- Scenario
- Creating a database connection in Power Apps using an on-premises data gateway.
- Observed behavior
- The gateway and SQL Server database appear in the Power Platform admin center, but the gateway is completely missing from the dropdown list when creating the Power Apps connection.
Ensure you have administrator access to the Power Platform admin center and that your on-premises SQL Server host machine is powered on and connected to the internet.
Verify Gateway Environment, Permissions, and Settings
Check the foundational configuration to ensure the gateway is properly registered, online, and accessible to your specific account.
Data gateways are tied to specific environments and user permissions. Even if a gateway is visible in the admin center, it will not appear in Power Apps if there is a mismatch in the environment, tenant, or permission levels.
Log in to the Power Platform admin center, navigate to Data > Gateways, and ensure the target gateway's status is listed as Online.
Confirm that the gateway is registered in the exact same environment and tenant where you are trying to create the Power Apps connection. Connections cannot cross environments.
Ensure the user account attempting to create the connection has been granted 'Can use' or 'Admin' permissions for that specific data gateway.
When configuring the connection in Power Apps, verify that the server name and database name entered match exactly with the data source configuration originally set up for the gateway.
Looking for a Seamless and Free Office Alternative?
While troubleshooting database gateways can be highly technical, handling your daily documents doesn't have to be. WPS Office is a lightweight, fully-featured suite that provides excellent compatibility with Microsoft formats for free.
- 1. Download the installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the software: Run the downloaded file and follow the simple on-screen instructions to complete the installation.
- 3. Open and edit your files: Launch WPS Office and immediately start opening, editing, and saving your existing Microsoft Office documents without format loss.
Frequently Asked Questions
Why does my gateway show as offline in the Power Platform admin center?
This usually happens if the machine hosting the on-premises data gateway is turned off, disconnected from the internet, or if the gateway service has stopped running on the host machine.
Does the environment region affect gateway visibility?
Yes, the gateway's region must match the region of the Power Apps environment where you are trying to create the connection. If they do not match, the gateway will not appear in the list.
Can I share an on-premises data gateway with other users?
Yes, gateway administrators can share the gateway with other users or security groups within the same organization via the Power Platform admin center, granting them permission to use it for their own connections.
