Forum Discussion
Merging tables
Disable automatic relationship creation. Worst setting after auto date/time intelligence.
Create the relationships you need manually, 100% of the time. Don't let the product's AI try to figure your model out. It fails enough times to cause massive irritation.
Thank you very much for the detailed message.
I have merged tables exactly how you did (via powerquery).
The point that confuses me is a completely different relationship in a data model which is generated automatically. It is selected randomly. When I run the model it raises errors because of the duplicates based on the "filter relationship"
These duplicates are from the column which is in the "data model (filter relationship)".
Is there any chance of avoiding this error?
Thanks in advance for reply!
Disable automatic relationship creation. Worst setting after auto date/time intelligence.
Create the relationships you need manually, 100% of the time. Don't let the product's AI try to figure your model out. It fails enough times to cause massive irritation.
Thank you very much for the assistance!