Forum Discussion
Connection to SAP HANA DB
Hello Fam,
Can anyone please tell if we can connect to SAP HANA Database with Power BI?
What are the prerequisites for it?
3 Replies
- AnonymousNot applicable
Hi NidhiBhusari ,
You can refer to the methods in the following links to connect to SAP HANA database in Power BI Desktop:
1. ODBC DriverConnect to SAP HANA Database from Microsoft Power BI(Business Intelligence)
Connect SAP HANA to POWER BI Desktop
2. SAP HANA Power BI connector
Power BI with SAP HANA as a data source | SAP HANA Power BI connector
Connect to SAP HANA databases in Power BI
Best Regards
- NidhiBhusari
Helper IV
Hi Anonymous ,
I have downloaded the highlighted one on my system still unable to proceed further.Unable to see the dBase file in this list.
- AnonymousNot applicable
Hi NidhiBhusari ,
Please refer the content in the following links to install and configure ODBC Driver.
Installing SAP HANA ODBC Driver on Windows 64 Bits
Configuring SAP HANA ODBC Driver
I don't have an SAP account, so I can't do the relevant test. But I found the following case which can successfully connect to SAP HANA database, I hope they can help you.
Connecting to SAP Hana (Reply 2 from Jared Brown)
1. Install ODBC Driver
2. Uninstall and reinstall 2017 Visual C++ Redistributables
3. Change SAP HANA password
1. Install SAP HANA ODBC driver
2. Install SAP Netweaver RFC SDK
Best Regards