Symptom
Errors from Microsoft Excel:
- Make sure the external data feed server is available and that your connection information is correct
- Unable to obtain list of tables from the data source
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Create a Communication Arrangement for a Custom CDS View to be able to access OData service for the Custom CDS View
- With Microsoft Excel use the OData Data feed to conume the new OData service that you have created
- At this point you may see the error
Cause
- The $metadata file of the odata service must be requested at least once
- This may also happen if using Microsoft Excel 2013 without the Microsoft Excel Power Query Add On
Resolution
***WARNING***: The following steps suggest running third-party resources. Please note that the resources have not been tested by support and are not supported by SAP. Use of these resources is governed by the third-party. Exercise appropriate caution when applying third-party resources.
- Go to a browser and call the OData service metadata, for example, https://myXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/YY1_<ODATA-SERVCE>/$metadata
- If using Microsoft Excel 2013 you will also need to download the Microsoft Excel Power Query Add On
- Connect to an OData feed (Power Query)
Keywords
Power Query Communication Arrangement Custom Communicationn Scenario Custom CDS View metadata , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem
Product
SAP S/4HANA Cloud Public Edition all versions