How to use SAP S/4HANA data in Power BI

 

Which data source is best for using data from SAP S/4HANA? 

At Absoft we generally recommend the use of oData services from the SAP application instead of direct database connections. 

An oData service is available inside the SAP application, and authenticates with an SAP user. All of the functionality of SAP can be exposed through an oData service. Access to the data is secured by the roles of the SAP user. Only a licensed SAP user can access the data and functionality that they are licensed to use. Therefore, there is little risk of breaching SAP’s license terms. 

Connecting directly to a database is convenient. However, it means authenticating with a database user rather than an SAP user so it’s up to you to worry about securing access. If you have a runtime license where the database is purchased from SAP to use with the application only, connecting directly in this manner may be completely prohibited. Even with the correct database license, there is a risk of non-licensed users accessing SAP functionality and creating an indirect access problem. 

The biggest benefit of oData services is that they allow the SAP data to be modelled into a fully usable API format, with the correct data formats and annotations for usage in Power BI. Direct access to the database leaves only abbreviated German field names. Also, significant further modelling is required by an SAP specialist in Power BI to allow the data to be reported. 

 

What are oData services and how do I get them? 

oData is a standard protocol that enables web-based API for data to be queried in a standard way. oData is used in SAP Fiori applications for all access to SAP data. oData services are a standard feature of S/4HANA.   

S/4HANA has a wealth of standard oData APIs due to the use of Fiori, which you can browse at api.sap.com. If you cannot find a standard API for your requirement, an ABAP developer can create a custom oData service, often with minimal code using CDS views. 

 

Single Sign-On 

With oData services you can provide a seamless experience to the users with single sign-on (SSO). That means a user can securely access SAP data and functionality, with their own SAP user, without having to log in.   

Single Sign-On can be achieved using a variation on traditional OAuth, which is handled by Absoft’s custom connector for SAP Data in Power BI. Watch the video and read more about how to start using your SAP data from Power BI through SSO here. 

 

Absoft’s solution for Power BI 

As a Gold Partner of both SAP and Microsoft, Absoft are uniquely placed to help solve problems in using Power BI for SAP data. Learn more about Absoft’s solutions for complex SAP data visualisation with Microsoft Power BI here.

We’ve transformed businesses to data-driven enterprises, with solutions ranging from high-level design of a reporting strategy to resolving technicalities in connectivity to on-premises systems, authentication, and effective data modelling.