Forum Discussion

FZOU's avatar
FZOU
Helper IV
6 years ago
Solved

Mark as key

Hello,

 

I'm trying to mark a column as key but i can't find the new addition Mark as key, does any one know how to display it ? thank you.

Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi FZOU ,

     

    Which version of Power BI are you using? I have never seen this option in Power BI Edit Queries section before.

     

    Thanks,

    Pragati

6 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi FZOU ,

     

    Which version of Power BI are you using? I have never seen this option in Power BI Edit Queries section before.

     

    Thanks,

    Pragati

    • FZOU's avatar
      FZOU
      Helper IV
      6 years ago

      Pragati11  i'm using the latest version but i can't find it also,maybe it will be available in the next update, thank you any way for your response

      • beefbriskets0up's avatar
        beefbriskets0up
        Frequent Visitor
        2 years ago

        old thread I know, but it's in Dataflows, I've not seen it in the desktop version.

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi FZOU ,

     

    Sorry for that now in Power BI you need a single column to link two tables  and you can't define a key with two columns as you can in common databases. 

     

     

    If you want to create a relationship between two tables, please check this article.

    Or if you want to create relationships based on multiple columns, please check this article.

     

    If these don't meet your requirement, could you tell us why you want to mark a column as key?

    Clearly describing the issue will help more people to understand, and they will help you solve it quickly.

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JentonBI's avatar
    JentonBI
    Frequent Visitor
    6 years ago

    Hi FZOU,

     

    The only place I have seen "Mark as key" is in the query editor for a Dataflow entity, in the Power BI Service.