Skip to main content

    Power BI

    Needs Votes

    Allow Database Multiple Keys

    Vote (19) Share
    Sabine Oussi's profile image

    Sabine Oussi on 13 Jan 2016 15:33:11

    When connecting to SQL Server, tables relationships are allowed on only one key.

    If the field is repeated, it will not consider it as unique though it is since there is more than one key in each table.

    Please allow relationship management between multiple keys.

    Comments (2)
    Sabine Oussi's profile image Profile Picture

    Christian Eller on 16 Aug 2020 03:54:01

    RE: Allow Database Multiple Keys

    there is already an idea for that - please vote for 10321815 composite-key-support-in-power-bi

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10321815-composite-key-support-in-power-bi

    Sabine Oussi's profile image Profile Picture

    Jesper on 16 Aug 2020 03:52:03

    RE: Allow Database Multiple Keys

    I agree composite keys are a must have for real production scenarios.