3775861 - OData v4 import connection from S/4 HANA returns 404 during model creation in SAP Analytics Cloud

• When building a model on an OData V4 import connection, the error appears: “The following error message comes from the external data service: Response from external server has status code of 404.”
• OData V2 import connections work correctly in the same environment.
• OData V4 connection creation succeeds, and the OData service metadata can be accessed outside of the modeling step.

• SAP Analytics Cloud
• Acquiring Data into SAC using an ODATA connection from S/4 HANA

1. Create an import data connection to an OData V4 service and confirm that connection testing succeeds and metadata is reachable;
2. Start creating a model based on the OData V4 connection;
3. Proceed to retrieve data; the model building fails with “Response from external server has status code of 404.”

The OData service import connection in SAP Analytics Cloud to S/4Hana on-premise supports only OData service exposed via the V2 protocol. 

 Workaround: Expose data as OData V2  - Publish CDS views using @OData.publish: true or create a custom OData V2 service via SAP Gateway (SEGW), then consume it in SAC.

• KBA 2828688 -  Unable to build model on any standard OData service through import data connection to S/4HANA in SAP Analytics Cloud
• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

OData connection, v4, 404, external data service, model building error, build model, model creation, odata service, odata4, v2 works, metadata accessible, s/4hana, services , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem