Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
tania_AVUB
Regular Visitor

SAP B1 and Power BI connection ERROR- since new update

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:

tania_AVUB_0-1666885185487.png

 

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 

2 ACCEPTED SOLUTIONS
v-binbinyu-msft
Community Support
Community Support

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.

View solution in original post

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

Thanks,

Tania

View solution in original post

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.