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
Community SupportHi 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