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-keys
And if you find something easier, let us know.