SAP Knowledge Base Article - Public

3642207 - Error when importing data from Datasphere to SAP Analytics Cloud

Symptom

  • Attempt to refresh an import job that was working previously, and the error is displayed: "Error parsing service metadata: Could not parse as Edmx document";
  • Try to create a new model using the same query, and another error is displayed: "Unable to connect to datasource. Check the connection details and user credentials, and then try again."

Environment

SAP Analytics Cloud 2025.8.17 

Reproducing the Issue

  1. Log into SAC;
  2. Go to Modeler > Open the model;
  3. Switch to Data Management and attempt to refresh the import job, but it fails;
  4. Return to Modeler;
  5. Try to create a new model using the same query, and it also fails.

Cause

The OAuth token had expired in Datasphere, as it is valid for a period of 180 days. This behavior is similar to what is described in the KBA: 3271051 - Import Job fails due "invalid token" from SAP Datasphere OData API - SAP for Me.

Resolution

  1. Go to Datasphere;
  2. Go to Administration > App Integration;
  3. Add a new OAuth Client and set the 'Refresh Token Lifetime' to 180 days;
  4. Switch to SAC and edit the OData Connection to Datasphere with the new OAuth Client;
  5. Refresh the import job, and it will work; also, a new model using the same query will work.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAC, Analytics Cloud, import job, model, query, error, credentials, Error parsing service metadata, could not parse as Edmx document, unable to connect, datasource, refresh, token, OAuth, OData, connection , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0