Analytical tool connection to SAP S/4HANA Public C...

JAS3311 · ‎2025 Feb 10

Hello, can we connect to SAP S/4HANA Public cloud with some analytical tool like Power Query or Power Bi? If yes, how?

Thank you

regards

Maciej__Galica · ‎2025 Mar 07

Hello,

There are multiple ways in which you can achieve this:-

1- Odata Services - Standard SAP S/4 HANA Cloud Reporting

2. CDS Views (if available) - Custom Business Logic reports

3. REST APIs - when Odata service is unavailable.

Go to the SAP API Business Hub - https://api.sap.com/ , here serach for

SAP S/4HANA Cloud OData APIs
Identify the required API endpoint (e.g., for financial reports, inventory, sales orders, etc.).
Login to S/4 HANA Cloud - Fiori Launchpad
Communication Management --> Communication Agreement
Create Odata service and get serivce URL and Authentication details.
Use this URL to enter in PowerBI , authenticate with SAP User Credentials and Load the reports.

for your reference I am lisiting a few SAP blogs you can refer -

I hope this finds you helpful.

Thanks