Power Platform + SAP - Troubleshooting the On-premises Data Gateway setup

Sometimes, installing and configuring the On-premises Data Gateway does not work.
In this video we want to take a look at some common mistakes that can happen during the installation and way on how to fix them. We will look at the browser developer tool (F12), logs on the on-prem data gateway, but also security traces in the SAP System. For each topic we want to show the error and then also the steps to fix it.

➡️Topis that we look-at:
- Installation in the wrong region
- Using the SAP .Net Connector 3.1
- not deploying in the global assembly cache (GAC)
- Wrong configuration so the SAP Server
- Not enough permissions in the SAP System

1:00 Deployment in wrong region
3:40 Missing SAP .Net Connector
6:19 Wrong verison of SAP .Net Connector installed
10:05 Files not installed to Global Assembly Cache
11:45 Wrong username & password
13:40 Wrong properties for the SAP System: Hostname, System Number, Client
16:35 Missing permissions in the SAP System
18:55 Closing

Additional information on SAP .Net Connector
File locations:
C:\Windows\Microsoft.NET\assembly\GAC_64\sapnco
C:\Windows\Microsoft.NET\assembly\GAC_64\sapnco_utils

Installation Files:
C:\Program Files\SAP\SAP_DotNetConnector3_Net40_x64
C:\Program Files (x86)\sap\SAP_DotNetConnector3_Net40_x86

Related useful transactions in SAP:
- SU01: Create user / change password
- ST01: System Trace / Authorization check
- PFCG: Manage roles / profiles (important: S_RFC authorizations)

Error messages you might see:
⚡ Connection not found. Please create a new connection and change your application to use the new connection
⚡ testconnection: 404 Unable to establish connection
⚡ QueryExecutionReport: Could not load file or assembly 'sapnco, Version=3.0.0.42'
⚡ The dynamics operation requests to API 'saperp" operation 'GenerateJsonSchema' failed with status code ... Microsoft.Adapters.SAP.NCo.RfcClientConnection
⚡ LOCATION CPIC on local host with Unicode ERROR hostname unknown. Microsoft.Adapters.SAP.NCo.BaseConnection
⚡ FU_NOT_FOUND Function module BAPI_ does not exist
⚡ BadGateway - no RFC authorization for function module RFCPING

➡️

[ruchitarathod]

This is excellent, I could resolve my issue. Thank you

[sistemasfbm]

Hello, very interesting video. I tried with the dot net connector of sap but it didn't work. My problem is that when I try to create a new odata connection I get the error "Bad Gateway" in the power automate portal. Can you help me please?

[NilsDeusch]

Great video tutorial, but unfortunately it doesn't solve my problem. I have installed the gateway and it gets displayed in the list of gateway in the tenant with the status online. When i try to create a first flow with the action "Call SAP function (V2)" the selection box does not provide my gateway as a possible value. What can I do?

[floppystudio]

What are access needs to be connected sap user