Symptom
When trying to consume an OData feed from S/4HANA Cloud in Excel 2016, the following errors are displayed in Excel:
We can't use the data from this feed. Make sure te external data feed server is available and that your connection information is correct
Unable to obtain list of tables from the data source
Environment
- S/4HANA Cloud
- Microsoft Excel 2016
Cause
When requesting an Odata Data Feed from Excel, you clicked the button labeled "From Other Sources" on the Data Bar in Excel
Resolution
- To consume an Odata Data Feed from Excel 2016:
- Click the "New Query" button on the Data Bar
- Select "From Other Sources" from the resulting dropdown menu
- Select "From OData Feed" from the dropdown submenu
- Follow the prompts to specify the URL of the OData feed and the credentials for accessing the feed
- For further details, please also review the SAP Blog S/4HANA Cloud Integration | Microsoft Excel
Keywords
excel 2016 odata feed consume , KBA , BC-SRV-APS-COM , Maintain Communication System and Arrangement , Problem
Product
SAP S/4HANA Cloud all versions