Forum Discussion

ibourega's avatar
ibourega
Frequent Visitor
2 years ago

Getting data from SAP

Hello everyoone I am connecting to SAP (through Odata query) to get data and using this data to build a BOM (Bill of Material). The app is not working all the time as expected : It does not read ...
Need Help
metrica's avatar
metrica
Icon for Post Prodigy rankPost Prodigy
2 months ago

Hi ibourega,

 

The CSV issue should be investigated separately by checking its delimiter, encoding, and column structure. For the slow SAP OData refresh, you may also want to 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 only the required SAP services, entities, and fields and apply SAP-side filters before loading the data into Power BI. This may help reduce the amount of data transferred, although performance will still depend on the underlying SAP OData service and your Power Query transformations.

 

A 30-day free trial is available, and we would be happy to arrange a demo and review your scenario.

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

Support: https://metricasoftware.com/docs/sap/contact-support-sap/

 

Cheers,
Metrica Team