Forum Discussion
Data Modeling of Geographic Table
I am trying to relate two tables in power bi that contain geographic information and keep getting a many-to-many relationship. Is there a way to bypass this? The two table samples are included; ...
NaveenGandhi
Memorable Member
Memorable MemberAnonymous
Can you share your data or PBIX after removing sensitive information?
That will be useful to help on this further. if not see which are the duplicate keys in both tables and try to work on making them unique as well.
Unfortunately, I can't. I was however able to solve this by creating a bridge table that had just city and state information with no duplicates.