3391517 - Cannot fetch data from entity FormRouteStep in SuccessFactors in SAP Analytics Cloud (SAC)

• Got error "<query name> has failed to upload because the query  returned an empty dataset. Please check you datasource and try again." when create query based on SuccessFactors in SAC.
• If using OData services connection with freehand query, got error "<query name> has failed to upload because of an error in the plugin service. "

• SAP Analytics Cloud (Enterprise) Version 2023.8.18

1. Login to SAC.
2. Go to Modeler and create new model based on import data connection to SuccessFactors.
3. Select connection.
4. Select query "FormRouteStep".
5. Add data fields "formDataId", "dueDate", "completed", and "stepName" to the query panel.
6. Leave the filter "As of Today".
7. Click Create.
8. Notice error happened "<query name> has failed to upload because the query returned an empty dataset. Please check your datasource and try again."
9. If create using the OData services connection with freehand query, using connection and query.
10. Notice that got plugin error: 
    "SAP Test has failed to upload because of an error in the plugin service."

The entity FormRouteStep has a composite key "formDataId" and "stepOrder", details can be found in the SF help guide FormRouteStep:

Use OData service connection and freehand query, formDataId is the document ID of the Performance form, which can be queried via ad hoc report in SuccessFactors, e.g. 

The below from is the sample form data from SAP internal test system:

e.g. URL and freehand query used in SAC:

• Data Service URL: https://<API Server>/odata/v2
• Freehand query: /FormRouteMap(<formDataId>)/routeStep?$select=formDataId,stepOrder,stageName,stageType,current,overDue,stepDescription

KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem