Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I used to connect to SAP B1 and get all tables from the HANA database using ODBC power BI connector(It had an option of SAP HANA database).
However since the update, ODBC do not have an option of SAB HANA database.
Therefore I have to connect using SAP HANA DATABASE connector, but instead of tables, i get SAP views as below:
Please help and advise how I can get SAP HANA database tables, such as ORDR or RDR1 etc once connection is established instead of views or functions.
Thank you
#sap #powerbi
@pbi_user_rdg
Solved! Go to Solution.
Hi @tania_AVUB ,
Connect SAP HANA databases in Power BI Desktop, you must have the SAP HANA ODBC driver installed on the local client computer for the Power BI Desktop's SAP HANA data connection to work properly.
Please confirm the ODBC exist now.
For more details, you can read related document: Use SAP HANA in Power BI - Power BI | Microsoft Learn
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you SAP HANA ODBC driver was installed already, it just required configuration.
Thanks,
Tania
Hi @tania_AVUB ,
Connect SAP HANA databases in Power BI Desktop, you must have the SAP HANA ODBC driver installed on the local client computer for the Power BI Desktop's SAP HANA data connection to work properly.
Please confirm the ODBC exist now.
For more details, you can read related document: Use SAP HANA in Power BI - Power BI | Microsoft Learn
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you SAP HANA ODBC driver was installed already, it just required configuration.
Thanks,
Tania