SAP Knowledge Base Article - Public

3229486 - 'Skip Clause is not supported in CRM' error message appears when trying to build a query via Odata service in SAP Analytics Cloud (SAC)


When building a query in SAP Analytics Cloud (SAC) via Odata Service from Microsoft Dynamics CRM 365 the following error message occurs:

  • "The following error message comes from the external data service: status: 400 body: {"error"¡{"code":0x0",message":" Skip Clause is not supported in CRM"}}"


  • SAP Analytics Cloud (Enterprise) 2021.8.17

Reproducing the Issue

  1. Create new dataset/model.
  2. From a data source.
  3. Odata Services.
  4. Select Connection.
  5. Build a Query.
  6. Select table.
  7. Select required objects.
  8. Click Create.
  9. Observe the error message.


    • As KBA suggests: in order to bypass the limit for importing more than 1000 record per query, the server side paging ($skiptoken) has to be implemented.
      However, this $skiptoken is not supported when it comes to Microsoft Dynamics CRM 365. Which makes the workaround not doable. Therefore, the 1000 record per query limit can't be bypassed.


    This issue is currently under investigation by development.

    See Also

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


    odata, crm, Microsoft Dynamics CRM 365, Microsoft Dynamics SAC, Microsoft Dynamics odata, Odata 1000 limit, Odata limitation, odata 1000 record, Odata query, Microsoft Dynamics CRM 365 $skiptoken, skiptoken , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem


    SAP Analytics Cloud 1.0