Skip to main content

    Power BI

    Needs Votes

    Composite Key support in Power BI

    Vote (207) Share
    Srinivasan Turuvekere's profile image

    Srinivasan Turuvekere on 22 Oct 2015 21:59:36

    Provide support for composite keys natively as a modeling feature. This would be useful to create relationships between tables that join on multiple columns without having to create a surrogate key by concatenating fields

    Comments (16)
    Srinivasan Turuvekere's profile image Profile Picture

    Mike Burba on 05 Jul 2020 22:30:36

    RE: Composite Key support in Power BI

    At a client that just asked for this.

    Srinivasan Turuvekere's profile image Profile Picture

    Mike Donnellan on 05 Jul 2020 22:26:29

    RE: Composite Key support in Power BI

    I'll say. In the meantime kludge city, workaround SELECT CAST(PrimaryKeyComponent1, nvarchar(32)) + CAST(PrimaryKeyComponent2, nvarchar(32)) AS KludgeKey... swell.

    Srinivasan Turuvekere's profile image Profile Picture

    Sreenivas Amirineni on 05 Jul 2020 22:22:58

    RE: Composite Key support in Power BI

    Yes, Support it. It must be present in Manage Relationship tab.

    Srinivasan Turuvekere's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:18:18

    RE: Composite Key support in Power BI

    errr... Yeah.

    Srinivasan Turuvekere's profile image Profile Picture

    Jesper on 05 Jul 2020 22:15:47

    RE: Composite Key support in Power BI

    I agree this is a must and a bit strange it is not implementet.

    Srinivasan Turuvekere's profile image Profile Picture

    Srinivasan Turuvekere on 05 Jul 2020 22:08:09

    RE: Composite Key support in Power BI

    Added based on feedback from Frowns