SAP B1 and Power BI connection ERROR- since new update

[tania_AVUB]

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 

@Khristian 

[Anonymous · Accepted 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.

[Anonymous · Accepted 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.

[tania_AVUB · Accepted solution]

Thank you  SAP HANA ODBC driver was installed already, it just required configuration. 

Thanks,

Tania