Forum Discussion

marcel_powerbi's avatar
marcel_powerbi
Regular Visitor
4 years ago
Solved

S/4 HANA Performance with Power BI

Hello all,

does anyone use Power BI in conjunction with a S4/HANA ERP system and can tell me about the performance?

I am currently deciding whether to connect Power BI directly to the HANA database or to provide the data source for Power BI via an additional SQL server.

I would be very grateful for any experiences or tips from you.

Greetings Marcel

Show and Tell

3 Replies

  • marcel_powerbi's avatar
    marcel_powerbi
    Regular Visitor
    4 years ago

    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

     

    • marcel_powerbi's avatar
      marcel_powerbi
      Regular Visitor
      4 years ago

      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

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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 Regards

    Lucien