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