PowerBI not taking SAP (BEx) query restrictions into account

[Anonymous]

Hello all,

I'm trying to load a query made in SAP BEx query designer into PowerBI, however it's not showing the results in the same order as when I load the query through SAP BEx Analyzer. When I load the query into Powerbi, it loads every existing value in every row even if they're not matching. Example below, ARN should only have one unique number matching in the left column.  Anybody knows what's causing this? 

Output in SAP BW as it should show in PowerBI aswell:

[Anonymous]

Hello everyone,

I have the same problem. I load 2 or more columns from the same table or cds view from sap bw. In Power BI each value from each column is matched together. Instead of getting 10 rows I get a lot more. Has anyone else encountered this problem?

The example in the screenshot gives me 589 rows but it should have been 98.

Kind regards and thank you for your time,

SnSl

[Anonymous]

Hi,

All the columns are from 1 datasource (SAP BEx query).  I'm pretty sure this is not a PowerBI issue since options when loading a SAP query are limited and I've succesfully loaded SAP queries in the past.

Unfortunately it's confidential so I can't share the actual data but hopefully the example below explains what's happening. 

What it should be loading, and how it's showing in SAP BEx Analyzer as well:

How it's loading in PowerBI:

In PowerBI every value from one column is 'multiplied' by each value from the other columns, even though they're not matching. Basically all values existing in the SAP InfoProvider are loaded, the opposite of what a query is supposed to do. Hope this explains.

[Icey]

Hi @Anonymous ,

Are the two columns from two tables?

If so, please check whether the relationship between the two tables is appropriate.

If not, please share us more details.

Best Regards,

Icey

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