Connecting PowerApps to an Existing Enterprise Gateway

If you’re new to PowerApps, be sure to read my brief introduction to PowerApps HERE

In this session, I want to show you how to connect to an existing Enterprise Gateway.

If you already use Microsoft’s PowerBI, there’s a good chance you already use an Enterprise Gateway to connect PowerBI to your on-premises SQL Server databases. PowerApps can also utilise this gateway to retrieve data.

To connect to an existing Gateway, browse to the ‘Connections’ menu within PowerApps

Select ‘New Connection’

Locate ‘SQL Server’ from the list of data adapters and click on it

In the pop-up box, you’ll be prompted to choose between using a Cloud SQL Server service, or an on-premises data-gateway. Select Gateway

Below that, enter the relevant details for your SQL Server (we’ll select the gateway later)

Hopefully, your existing gateway will already be listed!

Then hit ‘Create’

If all goes well, your new connection will now be listed under ‘Connections’, and you can start building your apps