Importing SAP BW4HANA Composite Provider Data in Power BI

[Anonymous]

Dear Experts,

I am having difficulty when importing data from SAP BW4HANA Composite Provider. My composite provider are structured like below. When exported to ex

Material	Location
MAT001	L001
MAT001	L002
MAT002	L003
MAT002	L004

But Somehow when I import to power BI, it shows as below, which seems to be a union of the individual values in the 2 columns. Can anyone advise me what's wrong?

Material	Location
MAT001	L001
MAT001	L002
MAT001	L003
MAT001	L004
MAT002	L001
MAT002	L002
MAT002	L003
MAT002	L004

[amitchandak · Accepted solution]

@Anonymous , refer

SAP
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

[Anonymous]

Hi @amitchandak,

Thanks for the quick article @amitchandak , I'm really new to power BI. I can't seem to see the "ID" though, e.g. Material Number, instead I can see the "Description. e.g: Material Description. Can enlighten me further?

Best Regards

Andre Julius