Forum Discussion
creating relationships
trying to create relationship between two tables. can anyone tell me why its giving me this error and what i need to do to connect it? i am trying to link the corp ae table to corp ae table but its not linking. i know there columns in both that match becasue i checked them but why dosnt it detect it?
ankitpatira is right, it's about the keys.
What I end up doing is concatenating PK and FK as a new column and this column will be the new PK for the connected tables. But things get messy with complex data.
Allowing multiple keys relationship which is not supported is the solution, vote for it here if you find it beneficial
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11428449-allow-database-multiple-keysAnd if you find something easier, let us know.
rjunai200 Basically you need to consider it as PK FK relations in your database tables. What error means is that in one of your tables there has to be unique values which will be your PK table and other will be FK table.
