Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post 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
tex628's avatar
tex628
Community Champion
7 years ago

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.

  • Bakhtawar's avatar
    Bakhtawar
    Post 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
      Community 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
        Post Patron
        7 years ago

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