Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago

How to create inner join relationship in data model?

hi Guys,   i have inner joins relationships in postgres and want to reflect/reproduce the same relantionships in power BI.  How to do this in data model?   Best, Jacek
Need Help
jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
4 years ago

Hi, thank you. 

The issue is that i can not use any kind of relationship in my case:

 

i have not unique values in both columns. 
What is the best practice in this case? Should i create relationships in this case at all? 
Or just create new tables merged/joined in Power Query? 

 

In SQL i would create INNER JOIN between these tables and ...that's it. I would have proper filter prepared.

Best,
Jacek