SAP Knowledge Base Article - Public

3666051 - Consume Datasphere artifacts using Microsoft Excel via odata

Symptom

  • Consuming SAP Datashere content via odata api by Microsoft excel is not working

Environment

SAP Datasphere

Reproducing the Issue

  1. Access the OData URL provided in the case description using MS Excel.

Cause

Excel does not support the required authentication method for consuming OData from SAP Datasphere. Consuming SAP Datashere content via odata api by Microsoft excel is not supported

Resolution

  1. Use the SAP Excel add-in as an alternative method to access data from SAP Datasphere, for details check Exposing Data For Consumption.
  2. Refer to the following blog for details on accessing SAP Data Warehouse Cloud using SAP's Excel add-in: details at  Access SAP Data Warehouse Cloud with SAP's Microsoft Excel.  

Keywords

odata, sap datasphere, ms excel, authentication error, technical user ID, oauth authentication, excel add-in, dsp analytical model, data consumption, export limit, 100k lines, 1 million cells, authentication method, odata api , KBA , DS-BB-ODATA , To address issues related to Odata consumption API , DS-MD-AM , Analytic Model , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions