01-08-2019 12:28 AM
We have installed On-premise Gateway in Remote desktop and would like to connect SAP HANA and Power BI Desktop and create Reports on HANA Views.
Please provide the step by step procedure and prerequisites to connect SAP HANA.
i have searched in our community and it tells me that the prerequisites are
SAP HANA ODBC driver
SAP Netweaver RFC SDK.
Do we need to install SAP HANA ODBC driver,SAP Netweaver RFC SDK in the Remote desktop where On-Premise gateway installed or it locally?
01-08-2019 06:03 PM
You would need to install the SAP HANA ODBC driver on the machines that have Power BI Desktop and Power BI gateway installed.
To connect to SAP hana in Power BI Desktop, you can follow the guide in this article:https://docs.microsoft.com/en-us/power-bi/desktop-sap-hana.
To add SAP hana data source within Power BI gateway, please follow the instructions in this article:https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sap.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.