Forum Discussion
SimonJacobs
Helper I
Helper IRelationships 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:/...
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.
"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
Anonymous me too , curious about this information. Did you learn any things?
Best Regards,