On‐Premises Data Gateway - matteoparlato/Plucky-Phoenix GitHub Wiki

On-Premises Data Gateway WIP

How to Install and Configure On-Premises Data Gateway

This document provides step-by-step instructions for installing the On-Premises Data Gateway, configuring it for Power Platform, and enabling functionality for Power Apps and custom connectors.

1. Server-Side Setup

Install On-Premises Data Gateway

  1. Check prerequisites and installation guide of the On-Premises Data Gateway .
  2. Download the On-Premises Data Gateway installer from the Microsoft website.
  3. Run the installer and follow the on-screen instructions.

Log with a non administrator account

  • Use a user account without the Power Platform Adminitrator role account to sign in.
  • Register a new gateway on the computer.

image

  • Set gateway name and recovery credentials then click on Configure to complete the procedure.

image

2. Configure Gateway in Power Platform

Verify Gateway Functionality

  1. Navigate to Power Platform Admin Center.
  2. Go to Data (Preview) under the administration panel.
  3. Ensure the connection is active and functioning correctly by clicking on the refresh icon. The check should report Online status.

image

  1. Open the Manage Users section in the Gateway settings and share the gateway to individual users by assigning the Admin Role.

image

image

3. Configure Custom Connector in Power Platform

Enable Connection via On-Premises Data Gateway

  1. In the custom connector settings, enable the option "Connect via On-Premises Data Gateway".

image

  1. Save the changes using the Update connection button.

Key Configuration Points

  • Host: If using an IP address ensure it is configured for HTTP and SSL is disabled in the Business Central service configuration.
  • Security Settings: Set authentication to Basic Authentication.

4. Set Up and Test in Power Apps

Steps to Enable Power Apps Functionality

  1. Navigate to Apps and launch the published Power App.
  2. Sign in (if required) and Allow the application to use the required connectors. ==The Power App will not function until the connection profile is manually updated with missing parameters. This is required due to a recent Power Platform change.==
  3. Navigate to Connections in Power Apps.
  4. Locate and edit the connection profile created from the app.
  5. Enter the following details:
    • Username.
    • Password.
    • Data Gateway.
  6. Save the changes.
  7. Relaunch the published Power App.
  8. Verify that it is now functioning as expected.

Additional Notes

  • Always validate the configuration steps after each phase to avoid issues.
  • Ensure all security settings comply with organizational policies and best practices.