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 *

Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016
Populate a table by looping through items in a list / another table
Format or Remove Borders from a Slicer or Timeline in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Showing Data Bars as a 'Proportion to Total' in Excel

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 2022 - Theme by ThemeinProgress