Defining Relationships with Multiple columns in the primary and foreign keys - Oracle Database

[kbirchmore]

I am working with an oracle database and pulled in my data tables. Now I am trying to setup the relationships to the tables using the primary keys/foreign constraints on the tables.  Power BI did not detect the primary keys like other tools I have used to query (MS Access, Crystal Reports, etc) so I tried to define these in Power BI but I only seem to be able to create a relationship on a single column and not multiple columns.  Am I missing something?  

Table 1

COMPANYID, SUBCOMPANYID - is the primary key

Table 2

COMPANYID, SUBCOMPANYID, CLAIMNO - is the primary key

I want to create the relationship between these two tables using the columns COMPANYID and SUBCOMPANYID.

Kris

[rajulshah · Accepted solution]

@kbirchmore ,

In Power BI, you can have only one active relationship between 2 tables.
You can refer to the below article:
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive