Forum Discussion

AKKortbaek's avatar
AKKortbaek
New Member
4 years ago

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. 

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 

 

Need Help

5 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    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's avatar
      AKKortbaek
      New Member
      4 years ago

      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 

  • metrica's avatar
    metrica
    Post Prodigy
    15 days ago

    Hi AKKortbaek,


    If you specifically need DirectQuery to HANA database objects, the native SAP HANA connector is the appropriate path. However, if your actual source system is SAP S/4HANA and your goal is to analyze S/4HANA business data rather than HANA database objects, direct HANA access may not be necessary.

    You may also evaluate Power BI Connector for SAP: https://www.sap.com/products/data-cloud/partners/metrica-software-inc-power-bi-connector-for-sap.html

    It reads supported S/4HANA OData services and provides Power BI with an OData endpoint, without requiring direct HANA database access. This is an Import/refresh approach rather than HANA DirectQuery.

    Documentation: https://metricasoftware.com/docs/sap/

    Cheers,
    Metrica Team