3538304 - Error: Missing Authorization for Service S_PRIVILEGED in Datasphere

The connection type is SAP S/4HANA Cloud. When validating connection, the error occurs:

----------------------------------------------------------------------------------

Connection "S4HANA_CLOUD" is valid, but not all features are available.
- Data flows are enabled.
- Replication flows are enabled.
- Remote tables can’t be used because of errors in the connection.
- Model Import is disabled.

Remote Tables: Unable to connect remote source: [SAP][ODBCforABAP] (08001) Open backend connection: Missing Authorization for Service S_PRIVILEGED., Code: 5921, SQL State: HY000
----------------------------------------------------------------------------------

SAP Datasphere

Lack of appropriate authority.

Refer to Using ABAP SQL Services for Accessing Data from SAP S/4HANA Cloud for full details of configurating such integration scenario.

On this help portal page, at step 3, "For more information about the above steps, see Exposing the SQL Service for Data Federation and Replication with Privileged Access in the SAP S/4HANA Cloud documentation. ", on which the linked page Creating a Communication Arrangement for Exposing the SQL Service contains what might be overlooked information at step 6".

• Take note of the service URL.

  It’s something like https://<hostname>/sap/bc/sql/sql1/sap/S_PRIVILEGED."

DWC, DS, S4HC, HC , KBA , DS-DI-CON , Connections , Problem