logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Connecting PowerApps to an Existing Enterprise Gateway

November 27, 2016 0 comments Article Advanced, PowerApps

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

Related

Tags: 2016, Business Intelligence, Data, Data Visualisation, Functions, Office

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

How did Microsoft’s Power BI come to lead the Gartner Magic Quadrant?

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2025 - Theme by ThemeinProgress