Issue Accessing OData Service Root from Fabric to SAP S/4HANA

AndreaPwC — Wed, 07 May 2025 10:45:19 GMT

Hello,

We are attempting to configure an OData connection from Microsoft Fabric to SAP S/4HANA, in order to consume OData services.

Our goal is to use this connection either via the Copy Data activity in Data Factory or through Dataflow Gen2—either approach is acceptable for our scenario.

We have set up an on-premises Data Gateway that has connectivity to SAP and includes all required libraries. We are using a service account that has the necessary permissions to access the SAP environment.

Following the official documentation (link), we tried to connect to the root of the OData service.

However, we encountered the following error:

Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: 
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (The server has not found any resource matching the Data Services Request URI)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (The server has not found any resource matching the Data Services Request URI)

Details:
Reason = DataSource.Error
ErrorCode = 10122
DataSourceKind = OData
DataSourcePath = https://<sap-hostname>:<port>/sap/opu/odata

Interestingly, when connecting directly to a specific OData service—for example:

https://<sap-hostname>:<port>/sap/opu/odata/sap/API_COMPANYCODE_SRV/A_CompanyCode

—we are able to successfully retrieve data.

The question is: how can we connect to the root OData service URL in order to browse and list all available OData services? We would like to avoid creating a separate connection for each individual OData endpoint if possible.

Thank you for your support.

Re: Issue Accessing OData Service Root from Fabric to SAP S/4HANA

v-prasare — Thu, 08 May 2025 12:21:05 GMT

please refer to below similar thead resolved in community and setup details. let me know if this helps you resolve your issue?

Solved: Ms Fabric SAP Hana Connector Issue - Microsoft Fabric Community

If your blocked here this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth

topic Re: Issue Accessing OData Service Root from Fabric to SAP S/4HANA in Dataflow

Issue Accessing OData Service Root from Fabric to SAP S/4HANA

Re: Issue Accessing OData Service Root from Fabric to SAP S/4HANA