Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
corporate_buddy
New Member

Joining Existing Data in Power Bi with Excel file

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? 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @corporate_buddy , hello Greg_Deckler, thank you for your prompt reply!

Check the following solutions:

 

  1. 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".

  2. 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.

 

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@corporate_buddy Sample data would help tremendously. Hard to know what is wrong without seeing things. 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

corporate_buddy_0-1734707963992.png

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. 

Anonymous
Not applicable

Hi @corporate_buddy , hello Greg_Deckler, thank you for your prompt reply!

Check the following solutions:

 

  1. 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".

  2. 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.

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.