Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
My issue is that I have data coming from SQL serber which is already in Power bi. I created a spreadsheet with some metrics and want to join that to the data. The data has common field Cusotmer ID but that's all. When I try to join through relatiosnhips the filters for other fields do not work for example district or item etc. I have tried to also Merge queries but it refuses to find all similar Customer ID. Any thoughts on how I can solve this?
Solved! Go to Solution.
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:
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.
@corporate_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:
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |