SAP Knowledge Base Article - Public

3480481 - Business requirement to use Power BI to retrieve data from application "Sales Volume - Flexible Analysis" - S/4HANA Cloud

Symptom

It is a business requirement to use Power BI to retrieve data from application "Sales Volume - Flexible Analysis".

Environment

SAP S/4HANA Cloud Public Edition

Resolution

As MS Power BI can consume OData protocol it is possible to:

  • Build one Custom CDS View (Scenario: External API) which is based on I_BillingDocumentItemCube (analytical cube of report Sales Volume - Flexible Analysis)
  • Create corresponding Custom Communication Scenario and Communication Arrangement
  • Consume the OData protocol to build above in MS Power BI

Please be aware that this has not been tested and is not guaranteed to meet your business requirement!

See Also

Fiori - Sales Volume - Flexible Analysis

Keywords

MS Power BI, Sales Volume - Flexible Analysis, Odata, protocol, custom, cds view, analytical query, scenario, External API, I_BillingDocumentItemCube, Communication Scenario, Communication Arrangement , KBA , SD-ANA-2CL , Analytics (Public Cloud) , How To

Product

SAP S/4HANA Cloud Public Edition all versions