Skip to main content
Microsoft Idea

Power BI

New

Relationship with more than one Primary Key

Vote (2) Share
Oliver Prodinger's profile image

Oliver Prodinger on 08 Dec 2022 12:53:23

If you add a relationship between two tables you can only use one primary Key. If you want relate two tables where you need two keys to get an unique relationship, you can only do this if you add an query and mark so much columns so you get an unique result.

It would be easier if you could add a relation between two tables with more than one primary key.