Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |