Forum Discussion

SimonJacobs's avatar
SimonJacobs
Icon for Helper I rankHelper I
9 years ago
Solved

Relationships with multiple look up tables

Hi,   I'm having problems getting a dashboard to work that uses multiple look up tables due to limitations in relationships between tables.  I've seen the problem discussed but the solution (http:/...
Need Help
  • austinsense's avatar
    austinsense
    9 years ago

    I'm having a bit of trouble imagining what you're describing, but here's what I would suggest:

     

    1. Power BI by default makes the relationships bi-directional, go ahead and turn that off on all the relationships - make them go only one direction.

    2. You already know this but I have to say it - don't connect your lookup tables directly to each other and don't connect your data tables directly to each other.

     

    But yeah take a little screenshot and that would help people help you.

austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
9 years ago

I'm having a bit of trouble imagining what you're describing, but here's what I would suggest:

 

1. Power BI by default makes the relationships bi-directional, go ahead and turn that off on all the relationships - make them go only one direction.

2. You already know this but I have to say it - don't connect your lookup tables directly to each other and don't connect your data tables directly to each other.

 

But yeah take a little screenshot and that would help people help you.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

"don't connect your lookup tables directly to each other and don't connect your data tables directly to each other." - Why is that?

Thank you 

  • bhrdrms's avatar
    bhrdrms
    Frequent Visitor
    8 years ago

    Anonymous me too , curious about this information. Did you learn any things?

     

    Best Regards,