Forum Discussion
SAP Hana Connector
Hi,
My company is changing to SAP S4Hana ERP.
Does PowerBi SAP Connector allow me to connecto to SAP tables so I can build some reporting or do I need to have Cubes in SAP Hana to extract info?
Thanks in advance.
- Anonymous7 years ago
Anonymous,
You can use SAP hana connetcor or SAP BW connector in Power BI Desktop to connect to the data source and check if the tables SAP tables are available.
However, if you need to connect to SAP S4 Hana CDS view in Power BI using SAP connectors, I am afraid that it is not possible, you can use OData Feed connector instead, for more details, please check my reply in this similar thread.
Regards,
Lydia
2 Replies
- AnonymousNot applicable
Anonymous,
You can use SAP hana connetcor or SAP BW connector in Power BI Desktop to connect to the data source and check if the tables SAP tables are available.
However, if you need to connect to SAP S4 Hana CDS view in Power BI using SAP connectors, I am afraid that it is not possible, you can use OData Feed connector instead, for more details, please check my reply in this similar thread.
Regards,
Lydia - metricaPost Prodigy
For S/4HANA business reporting, you do not necessarily need direct access to HANA tables or Calculation Views.
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 reads supported S/4HANA OData services and provides Power BI with an OData endpoint without direct HANA database access.