Connection to SAP HANA DB

[NidhiBhusari]

Hello Fam,

Can anyone please tell if we can connect to SAP HANA Database  with Power BI?
What are the prerequisites for it?

[v-yiruan-msft]

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

[NidhiBhusari]

Hi @v-yiruan-msft ,

I have downloaded the highlighted one on my system still unable to proceed further.

Unable to see the dBase file in this list.

[v-yiruan-msft]

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