Forum Discussion

emrei's avatar
emrei
Helper I
2 years ago
Solved

Connecting SAP to Powerbi

Hi everyone,   Everyday, I have a dashboard that uses an excel file extracted from SAP. Everyday, I go to SAP and extract a variant report to excel. I then replace the yesterdays excel file with th...
Need Help
Tips and Tricks
metrica's avatar
metrica
Post Prodigy
1 month ago

Hi emrei,

 

The best connection method depends on your SAP system. If you use a supported SAP S/4HANA environment and the required report data is available through activated OData services, you may evaluate Power BI Connector for SAP:

https://www.sap.com/products/data-cloud/partners/metrica-software-inc-power-bi-connector-for-sap.html

 

It lets you select SAP services, entities, fields, and filters, then provides an OData endpoint for Power BI with scheduled refresh.

 

This can replace the daily Excel export if the OData services contain the same data required by your report.

 

A 30-day free trial is available.

 

Documentation:
https://metricasoftware.com/docs/sap/

 

Cheers,
Metrica Team