SAP Hana DB objects are not getting reflected in Power BI Desktop

[Anonymous]

Hi, I am trying to connect the SAP Hana DB components to Power BI desktop. The login happes successfully, however I am not able to see the contents inside. Please find below the screenshot.

When I was checking the previlages from my username OBIUSER, I have the requried previlage to see the DB and select the table records in SAP Hana Studio. Please find below the screenshot. I have the access to the DB called "SAPHANADB"

I have also successfully installed the SAP ODBC driver in my local desktop with requried servername and DB tenant to connect SAP Hana DB. Please find the below screen shot.

Now I am not sure what am i missing and why i can't see the DB "SAPHANADB" appearing in the contents of my Power BI desktop after connecting.

I am using the data source Database --> SAP Hana Database (I need to use this source only due to directquery option).

[vkarumanchi]

Hi @SabariPrabu,

If you expand the content you will get the databases and if you further expand you find tables and views 

Please make it as solution if its helpful.

Thanks,

Vkarumanchi

[amitchandak · Accepted solution]

@Anonymous , refer if these document can help a bit

https://blogs.sap.com/2018/10/02/sap-bw4hana-connectivity-options-in-microsoft-power-bi/
https://blogs.sap.com/2020/01/30/sap-bw-demo-and-microsoft-powerbi-desktop.-step-by-step-guide/
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sap-hana
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-sap-bw