Forum Discussion

Icon for Helper IV rank

Helper IV

5 years ago

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?

Anonymous

Not applicable

5 years ago

Hi NidhiBhusari ,

You can refer to the methods in the following links to connect to SAP HANA database in Power BI Desktop:
1. ODBC Driver

Connect 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

Icon for Helper IV rank

Helper IV

5 years ago

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.

Anonymous
Not applicable
5 years ago
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

unable to connect SAP hana

1. Install SAP HANA ODBC driver

2. Install SAP Netweaver RFC SDK

Best Regards