Direct query is not working with ABAP CDS view and BEx query as source

[vinay0508]

Hello Experts,

We have created ABAP CDS view of type cube and BEx query in S4HANA. We are ableto connect using the Import data and working fine.

Issue - 1) Direct query is not working with ABAP CDS view and BEx query as source.

2) ABAP CDS view of type query is not visible in Power BI

Please help me on the above issues.

Thanks,

Vinay

[Anonymous]

Hi @vinay0508 ,

You can refer the following links to connect it:

Connect to SAP HANA data sources by using DirectQuery in Power BI

Create CDS views in SAP S/4HANA Cloud and consume them as APIs

ABAP CDS - From a CDS View to an OData Service for Analytics

Best Regards