Forum Discussion
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 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
4 Replies
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
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))
I'm interested if you have other ideas to test.
thank youhas anyone ever encountered this problem?
