cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AKKortbaek
New Member

SAP HANA Connection. No Content.

Hi all, 

I'm trying to connect to a HANA Cloud data base using the PowerBI "SAP HANA Database" connection. 

I'm able to connect, but I don't see any objects. I know there are tables and views and when e.g using Tableau then I see them. 

Any idea why I don't see anything? 

It works fine with the "ODBC" connector, but I don't want to use that. 

AKKortbaek_0-1645109085150.png

I've already downloaded the "SAP HANA ODBC driver"  and I'm able to make a connection via the "SAP HANA Adaptor". I just don't see any objects in the navigator. 

 

Thanks, Anders 

 

4 REPLIES 4
yhablatou
Regular Visitor

@AKKortbaek  did you find the solution ?

No. Unfortunately not. 

v-easonf-msft
Community Support
Community Support

Hi, @AKKortbaek 

To use SAP HANA, 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.

You can download the SAP HANA Client tools from SAP Development Tools, which contains the necessary ODBC driver. Or you can get it from the SAP Software Download Center

For more information, please refere to Connect to SAP HANA databases in Power BI .

 

Best Regards,
Community Support Team _ Eason

Maybe I was not clear. I already downloaded and installed the SAP HANA ODBC Driver. It also works fine if I connect via ODBC. 

I get the problem when using the "SAP HANA Database" connector. I want to use the "Direct Query" option and that is not available when I use the ODBC connector. 

BR, Anders 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors