Unable to find the view with S4HANA connection using ODBC Driver.

[MangeshVC]

Hello All,

I have connected to S4HANA in Power BI Desktop using SAP HANA DATABASE option in Get Data.

For the same I have used the ODBC driver & the connection is successful. I want to access the CDS view.

When I connect to datasource & the available table list gets opened. But I could not able to locate the required table(CDS View).

But the same table(CDS View) I do get, when I use the Advanced Option of writing the SQL Query.

I am unable to understand the issue.

Please guide.

[v-tianyich-msft]

Hi @MangeshVC ,

Being able to CDS table in power query means that the connection is successful, please check if any table is hidden. Or refresh all data, right click CDS table, open enable load.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[MangeshVC]

Hi @v-tianyich-msft 

          Thanks for reply. 

          But the issue is I am unable to locate the CDS Table itself in the database.

          It can only be accessed using Select query in advanced option & it works for import mode.

          But the same option is disabled for Direct query.

          The CDS has used the required annotations as well as the OData released.