Mark as key

[FZOU]

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.

[JentonBI]

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.

[v-zhenbw-msft]

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.

[FZOU]

@v-zhenbw-msft  your response is very useful thank you

[Pragati11 · Accepted solution]

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]

@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]

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