Power BI and SAP BW Composite provider

[michaeldurieux2]

Hi Community,

Context : I have a SAP Hana view with only about 130 rows.

Due to licence constraints (FULL USE on SAP), I use a BW Compostive Provider to project my SAP Hana View and I aim to call this Compositve provider using SAP BW connector inPower BI.

Issue : my row are multiplies when I use Power BI as if there was no link with my data (Cartesian product ?).

1. My SAP Hana View

2. My BW Compostive provider where I project my SAP Hana View with ONE-ONE relation

If I show the data on my composite provider, it's OK (the same as in my Hana View).

Sample :

And I me Power BI, I don't see the same thing, my rows are multply for each column.

Any idea ?

Thank for your help !

[amitchandak]

@michaeldurieux2 , are you using HANA connector or BW connector?

HANA in as relation DB ?

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

[michaeldurieux2]

@amitchandak

I use a BW Embedded on Hana and the connector SAP Business Wharehouse.

I have edited my screenshot to be more relevant (it's seems o make a Cartesian product ?).