Detecting Relationships between tables

[Bakhtawar]

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 

[tex628]

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]

---

@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]

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]

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