SAP HANA Connection. No Content.

[AKKortbaek]

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. 

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 

[yhablatou]

@AKKortbaek  did you find the solution ?

[AKKortbaek]

No. Unfortunately not. 

[v-easonf-msft]

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

[AKKortbaek]

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