Forum Discussion
hi_world
3 years agoHelper III
Power BI Nullable Column Merge Join Problems
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 ta...
amitchandak
3 years agoSuper User
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_world3 years agoHelper III
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))