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 trying to create realtionships manually then this shows an error

 

 

where in qliksense this realtions work fine 

Need Help

4 Replies

  • 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.