Skip to main content

    Power BI

    New

    Allow Database Multiple Keys

    Vote (16) 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

    bbed4887 2c99-ea11-a811-000d3a579c39 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

    3bcc7c9d 8181-407f-b02e-f43f3fe6b59b on 16 Aug 2020 03:52:03

    RE: Allow Database Multiple Keys

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