Forum Discussion
SAP Hana Database
I connect from SAP Hana DB on premis, but databse tables not populated in power BI desktop. Cubes shown in power BI desktop instead of tables. How I connect to get tables to load data?
Hi Tabish85 ,
According to your describe, to load data from SAP Hana Database, you can follow these steps:
1. Select Get Data > SAP HANA database in Power BI Desktop.2.Enter the name and port of the SAP HANA server you want to connect to, and choose import mode(default).
You can refer to the official documentation for more information about import mode and Direct Query mode of SAP Hana Database in power bi.
Power Query SAP HANA database connector - Power Query | Microsoft Learn
DirectQuery for SAP HANA in Power BI - Power BI | Microsoft Learn
In order for you to solve the problem faster, you can refer to the following documentation
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
3 Replies
Tabish85 I had the same issue. What I have ended up with was connecting, instead of the native SAP Hana connector I used ODBC connector.
Here is further documentation:
https://docs.microsoft.com/cs-cz/power-bi/connect-data/desktop-sap-hana
https://developers.sap.com/tutorials/hana-clients-odbc.html
Kudos and mark as a solution appreciated 🙂Hi Tabish85 ,
According to your describe, to load data from SAP Hana Database, you can follow these steps:
1. Select Get Data > SAP HANA database in Power BI Desktop.2.Enter the name and port of the SAP HANA server you want to connect to, and choose import mode(default).
You can refer to the official documentation for more information about import mode and Direct Query mode of SAP Hana Database in power bi.
Power Query SAP HANA database connector - Power Query | Microsoft Learn
DirectQuery for SAP HANA in Power BI - Power BI | Microsoft Learn
In order for you to solve the problem faster, you can refer to the following documentation
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
