Forum Discussion
Joining Existing Data in Power Bi with Excel file
Hi corporate_buddy ， hello Greg_Deckler, thank you for your prompt reply!
Check the following solutions:
-
Remove Redundant Relationships: Ensure there is only one path between the "Average of Bins" table and the "CUSTOMER" table. You can remove the direct relationship "Average of Bins" -> "CUSTOMER" and keep the path "Average of Bins" -> "SALES" -> "CUSTOMER".
-
Adjust Relationship Directions: Ensure all relationships are unidirectional. For example,change both to single:
- "Average of Bins" -> "SALES"
- "SALES" -> "CUSTOMER"
This way, the data flows from the "Average of Bins" table through the "SALES" table to the "CUSTOMER" table, avoiding conflicts between direct and indirect paths.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-
Community Championcorporate_buddy Sample data would help tremendously. Hard to know what is wrong without seeing things.
So this is a picture of the relationships tab.
Customer, sales item are all from our SQL database. I am trying to join table Avg of bins to them with customer ID but running into an issue.
Hi corporate_buddy ， hello Greg_Deckler, thank you for your prompt reply!
Check the following solutions:
-
Remove Redundant Relationships: Ensure there is only one path between the "Average of Bins" table and the "CUSTOMER" table. You can remove the direct relationship "Average of Bins" -> "CUSTOMER" and keep the path "Average of Bins" -> "SALES" -> "CUSTOMER".
-
Adjust Relationship Directions: Ensure all relationships are unidirectional. For example,change both to single:
- "Average of Bins" -> "SALES"
- "SALES" -> "CUSTOMER"
This way, the data flows from the "Average of Bins" table through the "SALES" table to the "CUSTOMER" table, avoiding conflicts between direct and indirect paths.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
-