Relationships error - Cartesian product

Hi Anonymous

Due to your relationship is many to one, this may be a logic problem in power bi.

I build two kinds of relationships one to one and many to one.

Build table visuals:

Many to one get error and one to one is right.

If you want to get all name columns in one visual, you may build a new table by Merge in Power Qury Editor.

Select Company Table and Company Inspector Table

Then we select Inspector Name Column and ID_Inspector in Expand.

Result:

Then we do the same steps to merge this table with other two tables.

Result:

Build a Table visual, result is right.

You can download the pbix file from this link:  Relationships error - Cartesian product

Best Regards,

Rico Zhou

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