Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
11 | |
11 | |
7 | |
3 | |
2 |