Forum Discussion

Binway's avatar
Binway
Helper II
9 years ago
Solved

three table join

Hi I have three tables that I thought were in a standard star schema relationship. If I create a table in Power BI and drag in fields from the centre table and and one outside table it popula...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Binway,


    You can try to drag unique column to this visual to link the duplicate records, it may fix your issue.
    I build some sample data to test, but I can't reproduce your issue, can you please share you pbix file to test?

     

    Regards,

    Xiaoxin Sheng

Binway's avatar
Binway
Helper II
9 years ago

Thanks Eno1978,

I was only attempting to join the three tables together to produce a list like below.

I can join the Acctdata table to either the left or right but not both although this same data in 3 SQL Srvr tables joins fine.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Binway,


You can try to drag unique column to this visual to link the duplicate records, it may fix your issue.
I build some sample data to test, but I can't reproduce your issue, can you please share you pbix file to test?

 

Regards,

Xiaoxin Sheng

  • Binway's avatar
    Binway
    Helper II
    9 years ago

    My problem was some duplicate values in a table that should have been distinct, so it fixed my issue from that perspective.  So the resolution to this many relationship on either side of a table is some modelling in Power BI, maybe a bridge table or something is what I am detecting.  Luckily I don't have to do this now:)

     

    Thanks

    Binway