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 *

Showing a Picture Based on the Value of another Cell in Excel
Showing Data Bars as a 'Proportion to Total' in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Using the same Named Range in multiple worksheets, but with different values, in Excel
Creating Virtual Tables in Power BI Using DAX

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