Forum Discussion

Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
7 years ago

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...
Need Help
Bakhtawar's avatar
Bakhtawar
Icon for Post Patron rankPost Patron
7 years ago
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

 

 

 

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

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.

  • Bakhtawar's avatar
    Bakhtawar
    Icon for Post Patron rankPost Patron
    7 years ago

    thanks for your reply i try every realtionsship in power bi but did not working