Power BI Nullable Column Merge Join Problems

[hi_world]

Hello, 

Here you will find a description on the problem : https://cbailiss.wordpress.com/2022/09/03/power-bi-nullable-column-merge-join-problems/

I encountered the same problem using three tables in the powerbi model like this model:

Do you have an idea on how to force powerbi to generate a simple inner join without doing a cross join with the addition of this piece of sql code OR (X.a IS NULL AND Y.b IS NULL) ?

Best regards

[hi_world]

has anyone ever encountered this problem?

[hi_world]

I'm interested if you have other ideas to test.
thank you

[amitchandak]

@hi_world , Forcefully change the join between Account and Account customer to Many to Many. If needed change the filter direction Account customer to Account and make it both directional and then try 

[hi_world]

hello @amitchandak 
thank you for your reponse. 
unfortunately even the request has changed a bit but it is still doing the cross join and it is taking a long time.
it did not remove the sql code that is causing the problem (OR (X.a IS NULL AND Y.b IS NULL))