Forum Discussion
S/4 HANA Performance with Power BI
Hi marcel_powerbi ，
When you connect to SAP HANA data sources ，there are two options when connecting to SAP HANA，1.Treat SAP HANA as a multi-dimensional source (default) 2.Treat SAP HANA as a relational source
Treat SAP HANA as a multi-dimensional source (default) with better performance, you can use this option.And Treat SAP HANA as a relational source offers greater flexibility,performance can also be affected to some extent.
To learn more details ,refer:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-hana
https://community.powerbi.com/t5/Desktop/Connect-Power-BI-directly-to-HANA-Tables/m-p/1966583
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Hello Community,
Does anyone have experience with the S4 HANA as an ERP system in conjunction with Power BI as a reporting tool?
My question is: How much does Power BI affect the performance in the ERP system. Is there anything to consider here?
The alternative would be to put a seperate on premise database in between to save the performance in the ERP system.
I would be very grateful for any experiences and tips.
Best regards Marcel
Hallo zusammen,
wie kann ich meine Datenset's für meine Berichte archivieren? Wenn mein ERP-System nach gewisser Zeit anfängt seine Daten zu archivieren oder zu aggredieren, muss ich dann neue Berichte erstellen mit der Datenbasis der aggregierten/ archivierten Daten aus dem ERP-System? Oder muss ich die Daten auf einer weiteren Datenbank sichern, um meine Berichte weiterhin ohne Probleme verwenden zu können?
Grüße Marcel