Forum Discussion
Detecting Relationships between tables
Hi all I have few tables in qlik sense .. and there is some relationship between tables.. now i use same these tables in BI but there is not any relationship detect between tables.. when i am tr...
tex628 wrote:Please post a picture of the amount of distinct rows that you have in the two columns that you are trying to combine.
You should be able to find it in the bottom left of PBI Desktop when you highlight a column in dataview.
hello
check this please
Both of your tables comtain duplicate values, which is why the relationship isn't working. You can try changing the relationship from many to one -> many to many. Im not sure how well MS PowerBI handles many to many relationships but its worth a try.
The reason that this works in qlik is because theres working many to many relationships there.
thanks for your reply i try every realtionsship in power bi but did not working